Formatting Dates

[AuditPro13]

I have 2 columns, one has Month in written format (ex. December), the other has year (2018). I would like to create a new column to sat 12/1/2018. Any advice?

[Thableaus · Accepted solution]

Hi, @AuditPro13 

With Formula Tool - Field - New Date

DateTimeParse([Month] + "/" + ToString([Year]), "%B/%Y")

This will make your date in an Alteryx Date format.

Cheers,