Alteryx Designer Desktop Discussions

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

Date Format

bh1789
8 - Asteroid

I was using the following formula:

 

DateTimeFormat(DateTimeParse([ReviewedDate],"%Y-%m-%d"), "%b %y")

 

but the source data changed from "%Y-%m-%d" to 2024-Apr-16

 

can someone help me adjust my formula so that 2024-Apr-16 gives an output of "%b %y"

 

Thank you,

1 REPLY 1
Bren_Spill
12 - Quasar
12 - Quasar

@bh1789 - DateTimeFormat(DateTimeParse([Review Date Updated],"%Y-%b-%d"), "%b %y")

 

Date Time.JPG

 

Labels
Top Solution Authors