Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Works Perfect!
thanks Vegar