Alteryx Designer Desktop Discussions

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

Date time format into yyyyMM

bridgethutter
7 - Meteor

 

Hello,

 

I currently have the formula below - I am looking to turn it into a string formula to look like 201804. Seemingly easy but I am spending too much time on it! I had to change to date to add one month to the time period.

 

bridgethutter_1-1670870785581.png

 

Thanks,

 

Bridget 

 

2 REPLIES 2
PanPP
Alteryx Alumni (Retired)

Hi @bridgethutter 

 

I have uploaded a sample WF that accomplishes this.

 

Hope this helps. If it does, please like the post and mark it as a solution.

 

 

 

binuacs
20 - Arcturus

@bridgethutter One way of doing this

binuacs_0-1670871800756.png

 

Labels