Convert Text Date to DATE

[Judicael]

Hello,

How to convert text date 10/01/2017 08:26 , 14/03/2014 00:00 to date 10/01/2017, 14/03/2014

Thanks for your help.

[StarinieriG · Accepted solution]

Hi,

Date(Floor(Date#(date, 'DD/MM/YYYY hh:mm')),'DD/MM/YYYY')