Why is this formula not working as intended? Datetime

[terrellchong]

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]

Hi @terrellchong 

DateTimeFirstOfMonth() Is designed to give only first of current month. To get first of given month use formula like below

DateTimeFormat([Temp],"%Y-%m-01")

Workflow:

Hope this helps : )

[atcodedog05]

Hi @terrellchong 

You can also use

DateTimeTrim([Temp],"firstofmonth")

Hope this helps : )

[terrellchong]

so it basically ignores the year? 

[atcodedog05]

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 : )