Issue with dates in formula

User Talk Formulas
1

Hello,
First colum “date” is a date in european format (DD/MM/YYYY)
second column “test” is a formula {Date}+19 and format is also european

Here is the issue :
image

As you can see, today (17th march 2022 leads to 4th of May) but 16/03 leads to 4th of April)
When it’s today, the format goes to MM/DD/YYYY and I don’t know why !

Thanks

2

Please use the dateadd() function when “calculating” with dates.

1 Like
3

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.