Unable to filter table on displayed date!!

[miguelraokumar]

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.

[trdandamudi]

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

I Option:

Date(Floor(YourField)) as DATEField

or

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

[Bonnette]

---

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