Date Calculations

[scottvaughan]

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?

[comment]

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.

[scottvaughan]

Thanks. I found out that I had to have the fields evaluated in a particular order. Once I rearranged the order, things worked out fine.