SOLVED
how do I convert 31-Dec-2018 to 12/31/2018 using the formula tool?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
htalteryx
8 - Asteroid
‎02-07-2019
12:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Help
5 REPLIES 5
17 - Castor
‎02-07-2019
12:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
cmcclellan
14 - Magnetar
‎02-07-2019
12:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I was confused by your post, but I think I figured it out.
When Alteryx is using dates, the format it always yyyy-mm-dd
So I'm guessing you're using a string that contains "31-Dec-2018" or more precisely "dd-mmm-yyyy". If the string is called [string_date] then use this:
DateTimeFormat( DateTimeParse([string_date],'%d-%b-%Y') ,'%m/%d/%Y')
The DateTimeParse turns the string into a date, which makes it easy to do the DateTimeFormat and show in the format that you want.
‎02-07-2019
01:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much! I've been looking everywhere for this! I would never have figured this out on my own!
One more question: how do I convert 2018-12-31 to 12/31/2018 using the formula tool?
17 - Castor
‎02-07-2019
01:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-07-2019
01:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks! I figured it out.
