Decimal to Datetime conversion

[EN6924]

I have an excel file where there are columns in date-time format like below -

Response time

28-02-2022 10:53:22

28-02-2022 11:34:13

When I try to import the file in Alteryx, it's showing in decimal values like below -

How can I fix that?

[Luke_C]

Hi @EN6924 

You can use a multi-field formula and a todatetime() function to fix this:

[atcodedog05 · Accepted solution]

Hi @EN6924 

Here is how you can do it. The best way is to use the multi-field formula tool and ToDateTime() function.

Workflow:

Hope this helps : )

[TheOC]

hey @EN6924 

Can you please upload an isolated part of your excel spreadsheet?

Thanks,
TheOC

[atcodedog05]

Happy to help : ) @EN6924 

Cheers and have a nice day!

[EN6924]

It's still not working

[atcodedog05]

oh, Xls file format its an old and doesn't support a lot of features. Let me look into it 😅

[atcodedog05 · Accepted solution]

Hi @EN6924 

Here is the updated workflow

Hope this helps : )

[EN6924]

Great 🤗

It worked well.

[binuacs · Accepted solution]

@EN6924 you can convert them in to date format using the bellow formula

DateTimeAdd('1900-01-01',toNumber([Call Open Date]) -2, "days")