Hi, i´m trying to make a store query to bring me request from 7:00 pm to 7:00 am , every day so i can view the non business hours tickets. I use time span but didnt work. Can you help please.
Are you trying to see the
1. Service Desk requests opened from 00:00 today to 07:00 today and the Service Desk requests opened from 19:00 today to 23:59 today?
2. Service Desk requests opened from 19:00 yesterday to 23:59 yesterday and the Service Desk requests opened from 00:00 today to 07:00 today?
Hi Lindsay, thanks for the quick answer. Will be the second choice.
So, your Time Span definition would be:
Year +0 Month +0 Day -1 Hour 19 Minute 0
Year +0 Month +0 Day +0 Hour 6 Minute 59
Year +0 Month +0 Day +0 Hour 7 Minute 0
The Where Clause for your stored query would be:
open_date >= StartAtTime(\'NON_BUSINESS_HOURS\') AND open_date <= EndAtTime(\'NON_BUSINESS_HOURS\')
Thanks Lindsay, it works like charmed !!!