In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Date Format

Raj008
8 - Asteroid
‎02-01-2021 08:38 AM

Hi everyone,

 

I need to format the date 28-Jan-2020 to 1/28/2020, need help on this.

 

Thanks...

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
afv2688
16 - Nebula
16 - Nebula
‎02-01-2021 08:44 AM

Hello @Raj008 ,

 

You can use the following formula:

 

 

 

DateTimeFormat(DateTimeParse([Field1],'%d-%b-%y'),'%m/%d/%Y')

 

 

 

Untitled.png

 

Regards

Reply
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All