Converting text field to date

[Sharbel]

Hi,

I have column that contains "date" written in txt format (Date_inv)  , how can I convert it to date format ?

example:

please fine attached sample file

Best regards,

Sharbel

[Vegar · Accepted solution]

Try this script.

//Important that your system variable LongMonthNames matches the spelling you have for your months in your excel document
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

[Sheet1]:
LOAD
[Date_Inv],
[Date],
dayname(Date#(trim([Date_Inv]),'DD-MMMM -YYYY')) as Date_intepret
FROM [lib://Downloads/smobariki.xlsx]
(ooxml, embedded labels, table is Sheet1);

It will give you an output like this.

[Sharbel]

Works Perfect!

thanks Vegar