Excel Time input is wrong transformation from alteryx

Hello everybody,

i have a problem i have a excel input with this "13.03.2020 18:22:49" but when i view it in alteryx it gets transformated into "43903.765845" this. Doesn't understand why but more importantly i don't know how to transform it back into at least "13.03.2020".

if someone could help it would be really nice 🙂

LG Timo

Date Time

Transformation

Accepted answers

atcodedog05

Hi @Timo97

What is happening is date has been converted to numbers. Here is what you can do it. Convert it to date and then convert to required format. Be aware that Alteryx only ISO dateformat of yyyy-mm-dd rest will be considered as string.

Workflow:

Hope this helps : )

date format.yxmd

All comments

atcodedog05

Hi @Timo97

Hope this helps : )

date format.yxmd

mst3k

software typically stores dates as number of years/hours/minutes/days/seconds/etc since some starting point like 1/1/1900, so it can store them as numbers and turn that into a date.

the todate() function seems to be all you need to convert your number into a date format. how your date shows (year/month/day etc) should be easy for you to change if it's not already in the format you want by default:

Timo97

Thanks @atcodedog05 for all your answers before i post the next one i look more closely into all functions of alteryx 🙂

atcodedog05

Happy to help 🙂 @Timo97

Cheers and have a nice day!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335