Date Difference

[tdr_Dinesh]

Hi Team,

Could someone assist me with the following issue?

We have two date fields: one is the report date, which is always set to today using the formula report date = now() , and the other is a date field named SLA. We have written a rule using dateDiff(sla, {Report Date}, "DD") , but we are not getting accurate results.

[Giridhar.Prabhu]

Hi @tdr_Dinesh

I think the issue is due to the time portion and/or timezone conversion. Please truncate the two fields (truncDate(“DD”, {date field}) and then do your dateDiff.

That should solve the issue

Regards,
Giri

[tdr_Dinesh]

Thank you @Giridhar.Prabhu