Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcement: We have made updates to resolve a Page Not Found error. If you still get this error, please let us know in the Community Corner.
Highlighted
Not applicable

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

1 Solution

Accepted Solutions
Not applicable

Add Days to a TimeStamp

Hi,

Try:

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

Regards,

Yigal.

4 Replies
Not applicable

Add Days to a TimeStamp

Hi,

Try:

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

Regards,

Yigal.

Add Days to a TimeStamp

Hi

    

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

Celambarasan

Not applicable

Add Days to a TimeStamp

Perfect! Tks

qlikconsultant
Contributor II

Re: Add Days to a TimeStamp

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