In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Date format

BautistaC888
8 - Asteroid

Hello,

I need to replace my dates to this format:
From:
2021-02-01
To:
FEB2021.

Thank you.

2 REPLIES 2
echuong1
Alteryx Alumni (Retired)

You can convert this with the datetimeparse tool. I used a data cleansing to change everything to uppercase as well.

 

echuong1_0-1618861048107.png

 

apathetichell
19 - Altair

Of if you have some weird fear of the date/time tool you can do this in formula:

uppercase(datetimeformat([Field1],"%b%Y"))

Labels
Top Solution Authors