Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.