Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

10005970
6 - Meteoroid

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 Date1st day of Transaction month
2021-12-202021-12-01
2021-12-292021-12-01
2022-01-072022-01-01
2022-01-082022-01-01
2022-02-182021-02-01
5 REPLIES 5
patrick_digan
17 - Castor
17 - Castor

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

AngelosPachis
16 - Nebula

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
22 - Nova
22 - Nova

Hi @10005970 

 

2 more ways

 

atcodedog05_1-1645534600196.png

 

Hope this helps : )

 

10005970
6 - Meteoroid

That worked perfect thank you.

MarqueeCrew
20 - Arcturus
20 - Arcturus

@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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels