Problem with date in calendar

[julruiz123]

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

[johnw · Accepted solution]

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)).