SOLVED
Convert Date from yyyy-MM-dd to yyMMdd
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
mzlee
7 - Meteor
‎08-17-2023
12:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I am trying to convert the date from 2023-08-17 to 230817, when I try parsing using DateTime I get a Null output error.
thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
2 REPLIES 2
ShankerV
17 - Castor
‎08-17-2023
12:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @mzlee
Please use the below formula.
DateTimeFormat([Column name],"%y%m%d")
 
Note: The resultant column should be anything other than Date datatype.
18 - Pollux
‎08-17-2023
12:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you share your configuration? The DateTime tool works well - otherwise I might use a Formula and do DateTimeFormat([Date],"%y%m%d")
