Difference in Dates Calculations

[chevell]

I am trying to get the difference between the create date and a modify date. I have done this before in the past with no issue, but for some reason i can't get it to work now.

All i have is modify_date - create_date. It ends up giving me a negative 6 digit number. For example, 2/28/06 - 3/16/06 = -732386

Am I doing this completely wrong?

Thanks!

[John Mark Osborne]

You definitely should be getting a negative since your creation date is larger than your modification date. However, it shouldn't be that large. It looks like it somehow returned a date value and then converted it to a number. I am guessing your modify, date, creation date or calculation for elapsed time is set to the wrong type like number or text but I could replicate your results on a sample file.

[comment]

732386 is March 16, 2006.

If

something - 732386 = -732386

then

something = 0

Which means that either your modify_date is empty, or you are not referencing it correctly, or something else of that nature.