Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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