Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

hencovanee
Contributor II

Format yyyy-mm-ddThh:mm:ss+mm:ss to date

Hi all,

Could someone help me to format this field: 2013-06-12T11:00:00+02:00 to a date format like DD-MM-YYYY?

Thanks in advance.

Kind regards,

Henco

Tags (2)
1 Solution

Accepted Solutions

Re: Format yyyy-mm-ddThh:mm:ss+mm:ss to date

See here


talk is cheap, supply exceeds demand
3 Replies

Re: Format yyyy-mm-ddThh:mm:ss+mm:ss to date

See here


talk is cheap, supply exceeds demand
hencovanee
Contributor II

Re: Format yyyy-mm-ddThh:mm:ss+mm:ss to date

Thanks a lot Gysbert, just what I needed.

Regards,

Henco

Not applicable

Re: Format yyyy-mm-ddThh:mm:ss+mm:ss to date

TRY THIS

=date(date#(left('2013-06-12T11:00:00+02:00',10),'YYYY-MM-DD'),'DD-MM-YYYY')

Community Browser