SOLVED
need HELP, double to 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
DanielShen
5 - Atom
‎07-05-2023
08:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I went into a trouble for converting numbers (doulbe format) to date format in Alteryx.
e.g. numbers in excel 20230722, how to convert to date format as 22/07/2023 in Alteryx, thanks!
Solved! Go to Solution.
3 REPLIES 3
geraldo
13 - Pulsar
‎07-05-2023
09:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
convert double date to string
date1 = ToString([DateExcel]
and then use the tool to convert to datetime with the custom option like print
15 - Aurora
‎07-05-2023
09:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @DanielShen ,
Another way is to use Formula tool as below.
Input & Output
Input | Output |
20230722 | 22/07/2023 |
Expression in Formula tool
DateTimeFormat(DateTimeParse(ToString([Input]),"%y%m%d"),"%d/%m/%Y")
‎07-05-2023
09:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
really appreciate your timley help. :)
