Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Date conversion

PB41091
8 - Asteroid

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
21 - Polaris

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

 

binuacs_0-1664884102306.png

 

PB41091
8 - Asteroid

It worked, thanks.

Labels