1 Reply Latest reply on Nov 25, 2013 5:37 PM by Shawn Wallwork

    Can't compare datetime and string values

    Kim Trop

      I get this error when writing an IF statement:  "Can't compare datetime and string values".  I need to group Receiver Province into groups EAST & WEST.  However the grouping changed after a certain date so Manitoba was in the West Province group until [Ship Date] => '2013-10-01' then it moved to the East Province group.  Here is my feeble attempt to write this.

       

      IF [Receiver Province] = 'Manitoba' AND [Ship Date] > '2013-09-30' THEN 'EAST' ELSE 'WEST' END

       

      @Dan Huff