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
Hi Mario,
just a thought, but have you tried simply modifying the display format of the [Date] column, like so:
Grtz
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.
Hi,
You have to first convert from text to number then you can format it in date.
regards
Hi Mario,
yes cvo shown you the correct approach.
Converting it to number first then following David’s method did the trick for me.
Thank you everyone for your help!
