Jump to content

Date Calculations


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

Recommended Posts

I want to do a few things with dates. They are:

Calculate whether today's date is past the due date of a job.

See how long it took to process a job from the date the record was entered to date it was marked closed. Are there functions that let me evaluate a date as a number?

Link to comment
Share on other sites

The date IS a number. To calculate whether today's date is past the due date of a job, use:

Get ( CurrentDate ) > DueDate

This will return 1 if true, 0 when false (this calculation needs to be unstored in order to update with the current date).

To see how long it took from Date1 to Date2 use:

Date2 - Date1

This will return the number of elapsed days.

Link to comment
Share on other sites

This topic is 5707 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.