10 Replies Latest reply: Dec 13, 2016 9:45 AM by Aehman K RSS

    Trigger or Flag

    Dipesh Vadgama

      Dear Friends,

       

      I am stuck in my data, appreciate if any one can help me.

       

      I have a data with ID, Day.

      I what to know which id was present today & also yesterday then Trigger or flag it in other field as Yes.

      and to others as No (ID was present today but not yesterday or ID was present yesterday but not today)

       

      Eg.

         

      IDDayTrigger
      ID12345Yesterday
      ID12346
      ID12347Yesterday
      ID12348
      ID12349Yesterday
      ID12350Yesterday
      ID12351Yesterday
      ID12352
      ID12353Yesterday
      ID12354Yesterday
      ID12355
      ID12345TodayYesTrigger this as Id was present today and yesterday
      ID12346Today
      ID12347
      ID12348Today
      ID12349TodayYesTrigger this as Id was present today and yesterday
      ID12350TodayYesTrigger this as Id was present today and yesterday
      ID12351
      ID12352Today
      ID12353
      ID12354TodayYesTrigger this as Id was present today and yesterday
      ID12355Today