Jump to content

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

Recommended Posts

Posted

This one is right out of the book. I'm simply trying to set a variable to the number of days between two dates. My script step is:

Set Variable [$Diff; Get(Current Date) - Invoice Date]

What I get is $Diff = 179:24:37 ... which equals the days expressed in hours:mins:secs.

What is preventing the calculation from simply returning 7 days or 7.46 days? Is there a better way to calculate days between dates?

Thanks in advance for any help.

Posted

Thanks, comment. That was the nudge I needed. Upon inspection, Invoice Date is actually a Time Stamp field. I changed the calculation to use GetAsDate(Invoice Date) and it seems to work.

This topic is 5492 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
×
×
  • Create New...

Important Information

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