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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels