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
13 - Pulsar

Raj_1-1685526929621.png

 

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

use this to get output as 1997-09

 

 

Labels