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 |
Hi @10005970 How about something like Left([Transaction Date],7)+"-01"
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
That worked perfect thank you.
Here are some lasting postings concerning dates:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Marquee-Crew-s-Guide-to-Dates/ta-p/...
They are easier found using google ( @WillM )
Cheers,
Mark