Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Extract date format

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.  

Labels (3)
1 Solution

Accepted Solutions
Mauritz_SA
Partner
Partner

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

View solution in original post

1 Reply
Mauritz_SA
Partner
Partner

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

View solution in original post