topic Re: Converting text field to date in App Development

Converting text field to date

Sharbel — Sat, 28 Jan 2023 08:53:58 GMT

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

Re: Converting text field to date

Vegar — Sat, 28 Jan 2023 13:32:17 GMT

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.

Re: Converting text field to date

Sharbel — Sat, 28 Jan 2023 17:50:40 GMT

Works Perfect!

thanks Vegar