Why is this formula not working as intended? Datetime

Question

You can see that from Output

Temp is 2020-01-05

and I am expecting the datetimefirstofmonth will return 2020-01-01

but it returned 2022 instead

is there any misunderstanding of the formulas?

atcodedog05 · Answer

Hi @terrellchong

No lets say current month is Feb even though Temp might be 2020-01-05 it will return 2022-02-01. DateTimeFirstOfMonth() will always return first day of current month Similar to DateTimeToday()

Hope this helps : )

PorcedanDyedrops · Answer

so it basically ignores the year?

atcodedog05 · Answer

Hi @terrellchong

You can also use

DateTimeTrim([Temp],"firstofmonth")

Hope this helps : )

FOM.yxmd