Good evening everybody !
While working on the idea from Meng of a special column to determine if an event will happen next month or not (see Meng’s post bellow), I found something strange (and, I guess, buggy) : the month function from the formula form doesn’t consider the format setting of the date column.
For example :
I have a Date column with, on first row, 09/10/2020 (in European format).
Here are the results of the formula month({Date})
depending on column format setting :
- ISO (2020-10-09) > 10
- US (10/9/2020) > 10
- European (09/10/2020) > 9
I guess it’s no big deal to correct this, and it’s not really hard to get around the problem neither, but I just wanted to let you know !
Bests,
Benjamin