Convert from date to string (excel to alteryx)

[dunkindonut7777]

Hi I have a data here that contains a field with "date" format in excel but it was automatically converted in excel as "string". In result, the values appeared differently.

Example below:

Code (Excel)	Code (Alteryx)	Expected Output in Alterx
202207	2453-08-14	202207
202208	2453-08-15	202208

How can I convert it to its original format in alteryx? I want to convert it back as what the Code (Excel) field has shown, but with string value.

[flying008]

Hi, @dunkindonut7777 

FYI.

Spoiler

DateTimeDiff(ToString([Code]),'1899-12-30','days')

******

If can help you get your want, please mark it as a solution and give a like for more share.