Date Calculator and Calendar Drop Down not working since update

I forgot to mention that I did update to the latest version of the Calculated Fields form. Thanks!

Hi,

The issue is simple and is not related with the latest update of the plugin, the range of years assigned to the date field in your form has been:

-10,+10

but the correct format is:

-10:+10

Use the symbol (:), instead of (,).

Best regards.

Thanks for your fast response. I made that change (changing the comma to a colon) and it did bring back the drop down calendar, but now I am having a new problem. The first calculator (NTO Date Calculator) is supposed to add 45 days to the date entered in field 1 [the formula is cdate(fieldname1+45)] but it is subtracting 45 days. The second form (Lien Date Calculator) is supposed to add 90 days, which it is, but the calculated date is showing as dd/mm/yyyy instead of mm/dd/yyyy as all the other fields are programmed to show. I can’t seem to figure out how to fix either problem.
I appreciate your help.
Thanks,
Liz

Wait – I just realized the first form is actually adding the 45 days as programmed, but it is showing as dd/mm/yyyy like the second form. So I have the same problem with both forms.

Hi,

The CDATE operation accepts two parameters, where the second one is the format of the output date, for example your current equation is:

cdate(fieldname1+45)

but the correct would be:

cdate(fieldname1+45, ‘mm/dd/yyyy’)

In your second form the equation is wrong format. The current equation is:

fieldname11cdate(fieldname1+90)

but the correct one would be:

cdate(fieldname1+90, ‘mm/dd/yyyy’)

The current documentation of CDATE operation is incomplete, I will correct it immediately.

Best regards.

That worked – can’t thank you enough for your help!