Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to create date off string and numeric

shelbyswartz
6 - Meteoroid

shelbyswartz_0-1621377962463.png

How can I create a date column off of these three fields?

 

Thanks!

3 REPLIES 3
Luke_C
17 - Castor

Hi @shelbyswartz 

 

See attached, what you can do is concatenate the year, month, and day fields and wrap it in a datetimeparse formula:

 

Datetimeparse([Accounting Period Date - Year]+[Accounting Period Date - Month]+[Accounting Period Date - Day],"%Y%B%d")

 

Note: I set all 3 fields to be strings prior to the formula

 

Luke_C_0-1621380740578.png

 

hellyars
13 - Pulsar

@shelbyswartz  

 

@Luke_C  beat me to it.  I took a slightly different approach and used the Date Tool. 

 

changeDaTE.png

shelbyswartz
6 - Meteoroid

This works! Thanks Luke.

Labels