Time stamps between two dates

Anonymous — Tue, 24 Apr 2018 22:54:57 GMT

I have a start time stamps and end time stamp in my data. For example Start time stamp = 7/28/2016 1:20:00 PM and End time stamp = 7/29/2016 7:30:00 PM and working hours are 8 AM to 5 PM. I want to extract difference in time stamp for each day like according to given example output should be

Start tijme stamp	End time stamp
7/28/2016 13:20	7/28/2016 17:00
7/29/2016 8:00	7/29/2016 17:00

I am using

Date(StartDate+iterno()-1) as StartDate_update

resident MACHINE

while

Date(StartDate+IterNo()-1) <= Date(EndDate);

But it only extract the dates, I have to take care of working hours and weekends also . Any one any idea how should I solve this problems

Re: Time stamps between two dates

rwunderlich — Mon, 23 Jul 2018 15:58:51 GMT

Do you want to calculate the number of working hours between the timestamps?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

topic Re: Time stamps between two dates in App Development

Time stamps between two dates

Re: Time stamps between two dates