returning the 1st day of the month based on a date field

[10005970]

Hi Alteryx Community.

I have a Transaction date field in a workbook (the format is standard date Time YYYY-MM-DD) I want to add a column that will display the first day of the month in the same date time format. see example below

thanks in advance

EG

Transaction Date	1st day of Transaction month
2021-12-20	2021-12-01
2021-12-29	2021-12-01
2022-01-07	2022-01-01
2022-01-08	2022-01-01
2022-02-18	2021-02-01

[patrick_digan]

Hi @10005970 How about something like Left([Transaction Date],7)+"-01"

[AngelosPachis]

Hi @10005970 ,

In a formula tool, try the following expression

DateTimeTrim([Transaction Date],"firstofmonth")

That should give you what you're looking for.

Cheers,

Angelos

[atcodedog05]

Hi @10005970 

2 more ways

Hope this helps : )

[10005970]

That worked perfect thank you.

[MarqueeCrew]

@10005970 ,

Here are some lasting postings concerning dates:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Marquee-Crew-s-Guide-to-Dates/ta-p/...

https://community.alteryx.com/t5/Engine-Works/MarqueeCrew-s-Guide-to-Avoiding-Date-Frustration/ba-p/...

They are easier found using google ( @WillM )

Cheers,

Mark