need HELP, double to date format

[DanielShen]

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!

[geraldo · Accepted solution]

@DanielShen 

convert double date to string
date1 = ToString([DateExcel]
and then use the tool to convert to datetime with the custom option like print

[Yoshiro_Fujimori]

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")

[DanielShen]

Hi all,

really appreciate your timley help. :)