posted on January 5, 2021 Show version history

Before applying the latest updates / patches to our Workflow Server the following DATEDIF formula in a Token Calculator worked correctly:

DATEDIF(NOW(),%(RetrieveFieldValues_Date) , "M")

This formula would check the retrieved field date against the current date and would return either a positive or negative value. For instance, if it returned a -1 then I knew I had a record from last month.

After the latest updates it appears that it wants to throw an error instead of a negative value as seen below:

The start date is greater than the end date:  Function: DATEDIF Expression: DATEDIF(NOW(),%(RetrieveFieldValues_Date) , "M")

The error was thrown while testing the date 12/13/2020 with the NOW date being 1/5/2021

Reversing the variable order didn't help either as the start date of 1/5/2021 and the end date being 12/13/2020 would give back -12.

I would also like to add that Forms 10.4.444 still performs the calculation as Workflow used to. The following formula gives back the correct number in Forms:

=DATEDIF(DATE(2020,12,3),DATE(2021,1,23),"M")

 

0 0