Setting First Hour of the day

  • Thread starter Thread starter James Frater
  • Start date Start date
J

James Frater

Hello All,

Because we have people working a varity of shifts, including night shifts,
our working day starts at 0600 and finishes at 0559 (or 2959 for calculating
time sheets and hours worked).

As with first day of the week, is there anyway I can set the first hour of
the day?

Cheers

JAMES
 
There's not a setting for that, but you can use an expression to get the
effective date, by subtracting 6 hours from the time.

For example, if you have a field named ShiftTime, type an expression like
this into the Field row in query design:
EffectiveDate: DateValue(DateAdd("h", -6, [ShiftTime]))
 
Back
Top