Hi Admins,
Is this possible to filter issues created over weekend, exactly between below timings.
Every 6am IST Saturday to 6am IST Monday
If you search in any day of the week and u need last week
createdDate >= endOfweek("-210h") and createdDate < endOfDay("-162h") order by created DESC
Calc 1st number
-(24*8)-18 S M T W Th Fr Sat S
Calc 2nd number
-(24*6)-18 T W Th Fr Sat S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HelloIf you will search on monday
createdDate >= endOfDay("-66h") and createdDate < endOfDay("-18h") order by created DESC
It based on End of this Day
If u search on monday
1st number its
-24h end of Sunday
-24h end of Saturday
-18h its 6 am saturday
next number its
End of Monday
-18h its 6 am monday
Still have a question?
Get fast answers from people who know.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.