Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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