Change Date Format

[Anonymous]

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. 

[tresesco · Accepted solution]

Try:

Date(today(),'YYYY_MM_DD')

[Anonymous]

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

[tresesco]

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

[Anonymous]

Thank you agian! It was in a IF. 😄