We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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.
fireworks

Convert String to Date

Divyaverma2906
7 - Meteor
‎06-06-2023 01:54 PM

convert below string into date format

Preview file
9 KB
Labels:
Reply
0 Likes
5 REPLIES 5
geraldo
13 - Pulsar
‎06-06-2023 02:00 PM

@Divyaverma2906 

 

Function:
DateNew
DateTimeParse([Date],'%b %Y')

 

type date output

 

geraldo_0-1686085210094.png

 

Reply
Divyaverma2906
7 - Meteor
‎06-07-2023 07:33 AM

This is not working. Can you save the workflow

Reply
0 Likes
ArijitRoy
8 - Asteroid
‎06-07-2023 07:55 AM

hi @Divyaverma2906,

 

Try this one.

Convert String to Date.yxzp
Reply
0 Likes
ArijitRoy
8 - Asteroid
‎06-07-2023 07:56 AM

There is no Day, hence we have to add a day to get the Date format.

Reply
0 Likes
nagakavyasri
12 - Quasar
‎06-07-2023 08:18 AM

@Divyaverma2906 

Screenshot 2023-06-07 111800.png

Date.yxmd
Reply
0 Likes
Community Live
Live Cloud Quest Solve
Labels
Top Solution Authors
View All