Change default time range based on current time

[jlew715]

Hey all,

I need to have the default time range for a dashboard cover an overnight shift. This necessitates the time range change depending upon when the page is loaded:

Time user loads page	Time  range	Description
00:00 - 17:59	@d-1d+18h  to  @d+6	18:00 yesterday to 06:00 today
18:00 - 23:59	@d+18h  to  @d+1d+6h	18:00 today to 06:00 tomorrow

After a few hours of searching the forums I haven't seen another example where this is done, and I can't for the life of me figure out how to do it. Any help or just a nudge in the right direction would be appreciated!

Thanks,

[ITWhisperer]

-1d@d+18h to @d+6h

@d+18h  to  +1d@d+6h

[jlew715]

Ok, I can confirm those are the two ranges I need.

How / where do I specify those as the default? Where do I put the logic to say "IF the local time is after 18:00 but before 23:59, use @d+18h  to  +1d@d+6h ELSE IF the local time is after 00:00 but before 17:59, use  -1d@d+18h to @d+6h"?

[ITWhisperer]

Will this work

Earliest = +6h@d-6h

Latest = +6h@d+6h