0 Replies Latest reply on Jan 24, 2013 2:28 PM by 986926

    Campingn runs on unexpected dates

    986926
      Hi ,

      There is a segment to load a marketing campaign.

      In the segement tree , the Eligible Audience is set using a criteria .

      One of the filter is an advanced SQL filter in the criteria with the following condition :
      DAYNAME(CURRENT_DATE) NOT IN('Saturday','Sunday')

      However ,the camping run sometimes even on Saturday and Sunday.
      The other issue is that the campaign will not run on a weekday.This happens randomly.

      Kindly suggest on this issue.

      Regards,
      Archana