How can I use Alteryx to change date format?
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
phoebe_90
8 - Asteroid
09-22-2023
12:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
For example
change 2023-09-15 to 09/15/2023
Labels:
- Labels:
- Transformation
2 REPLIES 2
17 - Castor
09-22-2023
12:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @phoebe_90 you can do this multiple ways using a a formula such as Datatimeformat or the data time tool.
However I should add that Alteryx only recognises YYYY-MM-DD as a date format while you can transform your date in MM/DD/YYYY it will have to be or convert into a string field. Otherwise it be null if it was date data format.
EdwardCochrane
7 - Meteor
09-26-2023
08:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
There is a specific date time parse tool that makes this very easy. I suggest using that unless you have a good reason for using a formula.
