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.
if( weekday(EntryDate = 'Sat'), timestamp(EntryDay + 2), EntryDate) as WorkingEntryDay
i have a simlar problem. I try to add a day if the time is between 00:00:00 and 05:00:00
I tried :
if(time(EntryDay <'05:00:00'), timestamp(EntryDay+ 1), EntryDay) as Correct_Date
but it is not working.
if( weekday(EntryDate) = 'Sat', TimeStamp(Num(EntryDay) + 2), EntryDate) as WorkingEntryDay
Retrieving data ...