topic Re: To Find Next Monday for Week End in QlikView

To Find Next Monday for Week End

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a field called StartTime, which is MM/DD/YYYY hh:mm:ss format.

I want to write a logic like below:

if my StartTime is falling under Satday or Sunday, then it will show Next Monday 08:00:00, else StartTime.

Could anyone please help me how to put this in Qlikview Script.

Thanks,

Sarif

Re: To Find Next Monday for Week End

tresB — Wed, 01 Aug 2018 10:28:27 GMT

May be this?

If( Match(WeekDay(StartTime), 'Sat', 'Sun'), TimeStamp(WeekStart(StartTime,1,0)+8/24), TimeStart)

Note: Assuming your field is a real timestamp field and not a string field. Otherwise, you have to convert the string using parsing function like date#()/timestamp#().