2 Replies Latest reply on Jul 20, 2012 3:50 PM by Blair Gibb

    Date Filter shows times on Server

    Blair Gibb
    Blair Gibb Jul 12, 2012 1:37 PM

      Hi All,

       

      I have a date filter set up to show a range of dates.  It is based on a calculated field that truncates a date field:

       

      DATETRUNC('day',[SessionDate])

       

      The filter works fine.  In the development tool, it shows just the date without the times.  When I publish it to the server, just the dates show up at first, but as soon as the filter is touched, the times show up.  This occurs even when the 'Show times' checkbox is unchecked. 

       

      Is this a problem with DATETRUNC, or with the filter in general?