How to create date off string and numeric

[shelbyswartz]

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

Thanks!

[Luke_C · Accepted solution]

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

[hellyars]

@shelbyswartz  

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

[shelbyswartz]

This works! Thanks Luke.