Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

Date

Aleksandar1
7 - Meteor

I need the workflow to convert any type to date type yyyy-mm

3 REPLIES 3
FrederikE
13 - Pulsar

Hey @Aleksandar1,

 

What exactly do you mean by "any type"?

There are so many possible options to write a date, there is no workflow that captures everything. 

 

Please specify what you require. 

Aleksandar1
7 - Meteor

My enduser needs to enter the date in the form yyyy-mm, but I want to have control so that if he enters it in any other way, it will output to me in the format yyyy-mm

Raj
16 - Nebula

Raj_1-1685526929621.png

 

DateTimeFormat(DateTimeParse([Field1], "%d-%m-%Y"), "%Y-%m")

use this to get output as 1997-09

 

 

Labels
Top Solution Authors