Jump to content

Difference in Dates Calculations


This topic is 5682 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5682 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.