topic Problem with date in calendar in QlikView

Problem with date in calendar

julruiz123 — Wed, 30 Nov 2011 15:36:03 GMT

Hi,

I created a master calendar, but in some situations the filter works but in others doesn't works.

I found this situation and i don't know what is the problem. Both dates were formated with "date" but when it show the number of the date in "Fecha registros" include decimals.

How i can prevent that ??

Thanks

Problem with date in calendar

johnw — Wed, 30 Nov 2011 16:14:21 GMT

Date() is just a formatting function. It only affects how a value is displayed. You are displaying a timestamp as a date. You don't actually have a date. To get a date out of a timestamp, you could use floor() while creating the field. Something like date(floor(MyTimestamp)).