Date Format Conversion

[MarioBudiman]

Hi EasyMorph Team/Community,

Currently I'm trying to import data from spreadsheet source which contains horizontal date format, which I turned into vertical using unpivot function.

Original data source:

Unpivotted data:

I'd like to covert the unpivotted data type into date, however it failed.

Hoping someone can point out what I need to do differently to make this work.
Thank you in advance for your help!

Mario

[David]

Hi Mario,

just a thought, but have you tried simply modifying the display format of the [Date] column, like so:

Grtz

[MarioBudiman]

Hi David,

Thanks for your reply.
That doesn't work for me for some reason. I noticed that my default data type is text, while yours is number.

[cvo]

Hi,

You have to first convert from text to number then you can format it in date.

regards

[carlo.nigro]

Hi Mario,
yes cvo shown you the correct approach.

[MarioBudiman]

Converting it to number first then following David's method did the trick for me.

Thank you everyone for your help!