Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Formatting Dates

Highlighted
8 - Asteroid

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?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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,

Labels