
Contributor
2021-03-01
11:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
when I don't include the format 'YYYY/MM/DD' it brings me weird values as below
Thank you in advance
774 Views
2 Replies

Contributor III
2021-03-01
12:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Instead of the makedate function try:
Date(Date#(pstng_date,'YYYYMMDD'),'YYYY/MM/DD')

Contributor
2021-03-01
02:14 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @duchezbr
I applied this one. It worked perfectly. Thank you for your help.
734 Views
