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

    Add Days to a TimeStamp



      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.