4 Replies Latest reply on Jan 30, 2018 7:43 AM by Joe Oppelt

    Can't compare date and string values

    Diogo Braga

      This calculation works:

       

      {FIXED [App ID], [School Code],[Date Application (APPLICANT LOTTERY)]:MAX(IF ISNULL([Date Application (APPLICANT LOTTERY)]) Then 0 Else 1 END)}

       

      When I add a date restriction, the calculation doesn't work:

       

      {FIXED [App ID], [School Code],[Date Application (APPLICANT LOTTERY)]:MAX(IF ISNULL([Date Application (APPLICANT LOTTERY)]) OR [Date Application (APPLICANT LOTTERY)]>'09/30/2017' Then 0 Else 1 END)}

       

      I get the error 'can't compare date and string values'

       

      How can I fix it?