In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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