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