topic Re: Unable to filter table on displayed date!! in App Development

Unable to filter table on displayed date!!

miguelraokumar — Fri, 16 Aug 2019 10:59:09 GMT

my date has a datetime value that i converted to just display a date using: date([SESSION_DATE],'M/D/YYYY') AS [SESSION_DATE2];

It works in that it now does not display the time stamp in my table, just the date. I cant however filter it down to see all the rows for a date. I suspect that i am only seeing just the timestamp, and behind the scene Qlik sense is still trying to filter by the datetime value. Is that true? Any way to simply drop the time stamp from the load section?

Note: I am also using this field to generate an autocalender entry, but it didnt seem to work before i did that either.

Re: Unable to filter table on displayed date!!

trdandamudi — Fri, 16 Aug 2019 12:16:52 GMT

If you r field is datetime you can use one of the expression:

I Option:

Date(Floor(YourField)) as DATEField

DayName(DateTime) as Date

II Option:

If your DateTime field is in Text format then use as below:

DATE(timestamp#(YourFieldHere,'MM/DD/YYYY h:mm:ss TT')) as DATEField

Re: Unable to filter table on displayed date!!

Bonnette — Wed, 09 Oct 2019 10:37:44 GMT

same day essay wrote:
my date has a datetime value that i converted to just display a date using: date([SESSION_DATE],'M/D/YYYY') AS [SESSION_DATE2];
It works in that it now does not display the time stamp in my table, just the date. I cant however filter it down to see all the rows for a date. I suspect that i am only seeing just the timestamp, and behind the scene Qlik sense is still trying to filter by the datetime value. Is that true? Any way to simply drop the time stamp from the load section?
Note: I am also using this field to generate an autocalender entry, but it didnt seem to work before i did that either.

Hello,

Have you tried to use date(floor(<date field>)) ? I had a similar issue - you may also check the date function article: https://community.qlik.com/blogs/qlikviewdesignblog/2014/12/02/the-date-function