H
handsclark
I need to redefine the date of entries to match a 24 hour schedule that
starts and ends at 06:00 each day instead of 00:00.
I haven't been able to find anything related in Access help files or the
internet. So, I created a query with an IIf() statement that defines
time<06:00 as the previous day ( NewDate: IIf(Hour([time])<6, [Date]-1,
[Date]) ).
This query works just fine unless I try to confine the results to a specific
date using criteria ( [Enter a date], or Between [Start Date] And [End
Date], or even Date()-1 ). Once I define criteria on the field, it only
returns times between 06:00 and 11:59.
Could anyone tell me how to fix this, or if there is a better way to
accomplish this?
starts and ends at 06:00 each day instead of 00:00.
I haven't been able to find anything related in Access help files or the
internet. So, I created a query with an IIf() statement that defines
time<06:00 as the previous day ( NewDate: IIf(Hour([time])<6, [Date]-1,
[Date]) ).
This query works just fine unless I try to confine the results to a specific
date using criteria ( [Enter a date], or Between [Start Date] And [End
Date], or even Date()-1 ). Once I define criteria on the field, it only
returns times between 06:00 and 11:59.
Could anyone tell me how to fix this, or if there is a better way to
accomplish this?