4 Replies Latest reply: Dec 14, 2012 9:59 AM by Markus König RSS

    Add Days to a TimeStamp

      Hi,

       

      Do you know how can I add a day to one timestamp? (Ex. EntryDay + 2)

      So if a process entry day is during the weekend, the SLAs start to count since monday.

       

      Ex: Entry date:  24/03/2012 11:52:02 (Saturday)

       

      if( weekday(EntryDate = 'Sat'), EntryDay + 2, EntryDate) as WorkingEntryDay.

       

      Regards,

      Gonçalo