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

[Anonymous]

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

[Gysbert_Wassenaar · Accepted solution]

See here

[Anonymous]

Thanks a lot Gysbert, just what I needed.

Regards,

Henco

[#4]

TRY THIS

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