Hi all,
I have two formula columns, both pointing at one date field (“Date”). The formulas in the two fields are:
DATETIME_FORMAT(Date,‘W’)
and
WEEKNUM(Date)
For some reason, the week number in the WEEKNUM column is always 1 more than in the DATETIME...