Agentry - Determine Number of Days Between Two Dates

[Former Member]

I am trying to determine the number of days between two dates in an Agentry rule.  Can anyone post of an example of how to do this?  I tried it using the DIFF function but it doesn't seem to be working.

[Former Member · Accepted solution]

If the two fields you are using are date fields then you can do a Diff

Diff

- Date1

- Date2

If the fields are strings you will need to set them to Dates first
Diff

- Date

- - Date1

- Date

- - Date2

Are you going the difference on a screen, or just using it to check for a rule?

If you going to show it on a screen.  You need to make sure that the field you are using to display the outcome is not a Date field, other wise it will use the that date outcome, i.e. it would end up mostly some date of 1970.

[Former Member · Accepted solution]

I'm essentially trying to determine if TODAY - MyDate >= 7.  That will determine whether a subaction will run or not.

[Former Member · Accepted solution]

Chris

Try

GTEQ

- DIFF

- - DATE

- - MyDate

- 7