K1200 Posted February 11, 2010 Posted February 11, 2010 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.
comment Posted February 11, 2010 Posted February 11, 2010 Is Invoice Date a date field? Also, what do you use to view the variable?
K1200 Posted February 12, 2010 Author Posted February 12, 2010 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now