5 Replies Latest reply: May 15, 2014 9:52 AM by Grant Perkins RSS

    Filtering date field

    Marc Osborne

      I would like to filter records so that only dates prior to a certain date appear. My data is correctly listed as Date/Time type in general format. When I try to create a filter with the expression DATE<20040901 I get an Operand type error. This happens no matter what format the date is in. Any ideas?

       

      Thanks,

       

      Marc