Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, I'm an intern at a technology company and as a part of my internship process, I'm learning Qlik Sense.
I'm using Qlik Sense and I imported data from an Excel file. On this file, there is a date column named CreationTime but Qlik Sense does not recognize it as date so I manually change it, general to date. But on Date Picker extension, there is no date to select. Then, I used the following code but it didn't work again.
Date(CreationTime, 'YYYY-MM-DD') AS CreationTime,
Would you please help me? Thanks in advance.
Can you please try
date#(string, dateformat) instead of only Date.
can you share the actual date format from the data?
Please try as below
date(Date#(datefield),"YYYY-MM-DD")