topic Add Days to a TimeStamp in QlikView

Add Days to a TimeStamp

Wed, 28 Mar 2012 10:59:49 GMT

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

Wed, 28 Mar 2012 11:13:32 GMT

Hi,

Try:

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

Regards,

Yigal.

CELAMBARASAN — Wed, 28 Mar 2012 11:29:41 GMT

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

Celambarasan

Wed, 28 Mar 2012 11:34:00 GMT

Perfect! Tks

qlikconsultant — Fri, 14 Dec 2012 14:59:59 GMT

Hi,

i have a simlar problem. I try to add a day if the time is between 00:00:00 and 05:00:00

EntryDay='01.06.2012 01:24:41'

I tried :

if(time(EntryDay <'05:00:00'), timestamp(EntryDay+ 1), EntryDay) as Correct_Date

but it is not working.

Regards

Markus