need HELP, double to date format

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!

Parse

Date Time

Accepted answers

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

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

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

Hi all,

really appreciate your timley help.