Date Comparision on Rule Editor

[Former Member]

Hi Guys,

I am working on version 6.0 and trying to implement a rule which will check if the current date and time is greater then one particular date say stored date and time by 24 hours.

Issue is that rule is not working and even I am not able test the rule in rule editor.

Do we have a way to compare date in rule editor?

Thanks,

AB

[Former Member]

date time fields are saved in sections so use the value 86400 ( 60 sections * 60 minutes *24 hours)

Your rule is currently set up to see if yesterday is greater than the duedate of the work order.

Are you trying to check if the due date is greater than the current date + 1?
if yes, then
If
- GT
- - Workorder -> Due Date
- - SUM
- - - Date_And_Time
- - - 86400
- Unchecked
- UncheckedRed