Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date/Time Range selection
- Thread starter INPHOman
- Start date
Use the formula below to set all records to create a reporting date for each record. Then you can have the report select on records that fall within the reporting date range.
Formula:
ReportingDate
If Hour{RecordDateTime} < 6
Then Date{RecordDateTime} - 1
Else {RecordDateTime}
Formula:
ReportingDate
If Hour{RecordDateTime} < 6
Then Date{RecordDateTime} - 1
Else {RecordDateTime}
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question