Extract date format

[Anonymous]

Hello qlikers 🙂 , 

I have the date format DD.MM.YYYY hh:mm:ss for example 27.01.2020 07:30:58 and now I want to have only the date without the time. The result should be DD.MM.YYYY for example 27.01.20020 . 

I tried with 

Date(Floor(DateAndTime), 'DD-MM-YYYY') as Date

Do you have another solution? 

Thank you in advance! 🙂 Looking forward to reading some answers.  

[Mauritz_SA · Accepted solution]

Hi @Anonymous 

You can try the following if you want DD-MM-YYYY:

Date(Floor(Date#(DateAndTime,'DD.MM.YYYY hh:mm:ss')),'DD-MM-YYYY') AS Date

Or the following if you want DD.MM.YYYY:

Date(Floor(Date#(DateAndTime,'DD.MM.YYYY hh:mm:ss')),'DD.MM.YYYY') AS Date

Regards,

Mauritz