Skip to main content
Question

My start page transaction


Forum|alt.badge.img

Hello all. 
I am attempting to build some my start pages to support my team leaders shift handovers and I have already set up pages for early and late shift but I am struggling to pull information for night as the shift runs from 22:00pm to 06:00am each day so when inputting the time I can’t say created #TODAY# or #YESTERDAY#.
I basically want to see how many pallets we shipped and moved in that shift for performance but don’t know if I need to use SQL for which I am not sure how to use. 
Any help would be greatly appreciated

2 replies

COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • 218 replies
  • January 6, 2025

Hi ​@Dirk Sterling you could look at using,

where created_date between trunc(sysdate) - 1 + 22/24 and trunc(sysdate) + 6/24

you can replace created_date with the data you are referencing.

the between is looking at yesterday 22:00 (trunc(sysdate) - 1 + 22/24) and today 06:00 (trunc(sysdate) + 6/24)


Michael Kaiser
Sidekick (Customer)
Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 109 replies
  • January 8, 2025

Well done Jamie! :-)


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings