Date serial to date format

[tex628]

Hello, 

Im having an issue, i have a large dataset where the dates currently have the excel serial format. Is it possible to format this column to proper dateformat, perferably in the query?

It might also be relevant to say that the sourcefile is a .txt

Serial format/ Normal format

Br,

Johannes

[Sean · Accepted solution]

In the Query Editor right click the Serial Date column header and Change Data Type to Date.

[Stachu · Accepted solution]

in Excel 1st date is 01-01-1900, so you could just add nr of days since then
e.g. use this code for new column

#date(1900,1,1)+#duration([Serial Date]-2,0,0,0)

EDIT Sean's answer is way simpler, I'd go with it 

[tex628]

Both ways work, i managed to figure out ur proposed way before i had a chance to read the responses her 😛 

Thanks for the assistance,

J

[Sean · Accepted solution]

In the Query Editor right click the Serial Date column header and Change Data Type to Date.