Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Anonymous
Not applicable

Change Date Format

Hello qlikers 🙂 ,

I want to change the date format from 17.01.2019 to 2019_01_17.

I tested it with 

 

LET vDate = date(Date(Now(),'YYYY_MM_DD');

 

and

 

LET vDate = Date#((Date(Now())),'YYYY_MM_DD');

 

But unfortunately nothing works correctly. I only get 17.01.2019.

How can I change the todays date to this format YYYY_MM_DD ? 🙂

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

Labels (2)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Try:

Date(today(),'YYYY_MM_DD')

View solution in original post

4 Replies
Highlighted
MVP
MVP

Try:

Date(today(),'YYYY_MM_DD')

View solution in original post

Highlighted
Anonymous
Not applicable

we.PNG

Thank you for the answer! But how you can I see, it doesn't work. 

Highlighted
MVP
MVP

Something wrong must be happening at your end. Could your share screen shots of both the definition and value you are getting? 

Highlighted
Anonymous
Not applicable

Thank you agian! It was in a IF. 😄