Alteryx Designer Desktop Discussions

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

Formula for converting dates

calvincarr29
8 - Asteroid

I have a column that's showing dates as: 

 

2022-05-31 but I want it to show 05-31-2022 - What formula would I use? 

2 REPLIES 2
binuacs
21 - Polaris

@calvincarr29 

DateTimeFormat([Date],"%m-%d-%Y") - Change the data type to string

calvincarr29
8 - Asteroid

@binuacs You're the man! Thank you for coming in clutch today.

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