Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rmd_Rxd
Contributor
Contributor

Makedate function

Hi everyone 

Anyone to help?

I am new to Qlik sense and I am trying to apply makedate function to the field below to get date format as  'YYYY/MM/DD' but whatever I do it brings me null values when I include the date format 'YYYY/MM/DD' on the script 

Rmd_Rxd_1-1614616690030.png

when I don't include the format 'YYYY/MM/DD' it brings me weird values as below

Rmd_Rxd_2-1614617038296.png

Thank you in advance

2 Replies
duchezbr
Contributor III
Contributor III

Instead of the makedate function try:

Date(Date#(pstng_date,'YYYYMMDD'),'YYYY/MM/DD')

Rmd_Rxd
Contributor
Contributor
Author

Hi @duchezbr 

I applied this one. It worked perfectly. Thank you for your help.