Alteryx Designer Desktop Discussions

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

Date conversion

PB41091
7 - Meteor

I have date column with values populated as --> 2022-09-05

I want to convert these values as Sep 5, 2022 respectively

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

Hi @PB41091 the following formula will convert that date

 

 

DateTimeFormat([your field],"%b %d, %Y")

 

 

Date_04102022.JPG

 

You can find more information regarding the specifers for date formats in this link.

 

binuacs
20 - Arcturus

@PB41091 as mentioned by @JosephSerpis you can use the DateTimeFormat function for this

 

binuacs_0-1664884102306.png

 

PB41091
7 - Meteor

It worked, thanks.

Labels