1 Reply Latest reply: Nov 30, 2011 11:14 AM by John Witherspoon RSS

    Problem with date in calendar

    Felipe Ruiz

      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 ??

       

      dates.png

       

      Thanks

        • Problem with date in calendar
          John Witherspoon

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