SOLVED
Date/Time Parse
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
JeffJones
6 - Meteoroid
‎02-24-2023
08:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a date in the format of 2023-02-23. I am having trouble getting it to convert to a format of 2/23/2023.
I performed a date/time function to get the data to 2023-02-23 as shown below but can get it to end up as 2/23/2023
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
1 REPLY 1
Alteryx
‎02-24-2023
08:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you are starting with an actual date data type you can use DateTimeFormat([DateField], "%m/%d/%Y") to get it into your desired format in a formula tool.
https://help.alteryx.com/20223/designer/datetime-functions use this link as a reference page for date type operators
![](/skins/images/03E14B015E5210679CFB65D9FFC7B381/responsive_peak/images/icon_anonymous_message.png)