topic Re: To get next day 10 AM in QlikView

To get next day 10 AM

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

Hi All,

I have a field call Start Time as MM/DD/YYYY hh:mm:ss. I want a logic if the time is > 17:00:00, then it will return next day 10:00:00.

Like if the values is 25-06-2018 22:09:00, then it should show 26-06-2018 10:00:00.

Can you please help me to do this in script.

Thanks,

Sarif

Re: To get next day 10 AM

sunny_talwar — Sat, 11 Aug 2018 15:30:51 GMT

May be this

TimeStamp(If(Hour([Start Time]) > 17, Floor([Start Time]) + 1 + MakeTime(10), [Start Time])) as [Start Time]

Re: To get next day 10 AM

sunny_talwar — Sat, 11 Aug 2018 15:33:14 GMT

Or you can specify the format with TimeStamp

TimeStamp(If(Hour([Start Time]) > 17, Floor([Start Time]) + 1 + MakeTime(10), [Start Time]), 'DD-MM-YYYY hh:mm:ss') as [Start Time]

Re: To get next day 10 AM

sunny_talwar — Sat, 11 Aug 2018 15:36:37 GMT

Sorry, just realized that your date format is different then what it comes in as... may be if you Start Time is not read properly, you might need TimeStamp#() function to help Qlik understand your timestamp field

TimeStamp(If(Hour(TimeStamp#([Start Time], 'MM/DD/YYYY hh:mm:ss')) > 17, Floor(TimeStamp#([Start Time], 'MM/DD/YYYY hh:mm:ss')) + 1 + MakeTime(10), TimeStamp#([Start Time], 'MM/DD/YYYY hh:mm:ss')), 'DD-MM-YYYY hh:mm:ss') as [Start Time]

Re: To get next day 10 AM

mhmmd_srf — Sat, 11 Aug 2018 17:04:39 GMT

Thank Sunny...I did in below way and it is working..

Date(Timestamp(DayStart((Date([Start Time]+1)))+10/24),'MM/DD/YYYY hh:mm:ss')