Grouping by 24 hour time periods from 8:00:00 - 7:59:59 1

[LZido]

I am trying to group data by 24 hour time periods. For instance the first time period is from 1/1/2014 8:00:00 to 1/2/2014 7:59:59, the second 1/2/2014 8:00:00 to 1/3/2014 7:59:59, the third 1/3/2014 8:00:00 to 1/4/2014 7:59:59, etc.

I could set up groups by a specified order, but that would require specific date ranges and a lot of work.

The report should run by parameters in 24 hour increments starting at 8:00 am on a particular day through another date.

Any ideas?

I appreciate any help.

 

[Charliy]

IF HOUR({TIME FIELD}) < 8
THEN TOTEXT(({DATE FIELD}-1),"yyyyMMdd")
ELSE TOTEXT({DATE FIELD},"yyyyMMdd")

Use that formula to group by.

 

[LZido]

I am receiving an error: The results of selection formula must be a Boolean.

 

[Charliy]

This does not go in your select formula.

The formula above it what you would use for grouping.

If you want to select by 24 hour periods, then the formula gets changed slightly:
@day24
IF HOUR({TIME FIELD}) < 8
THEN {DATE FIELD}-1)
ELSE {DATE FIELD}

Then you can put in your select formula:

{@day24} in {?Date Range}

 

[LZido]

I think I am having problems because my data field is a date/time field. I do not have separate fields for date and time. Do I need to adjust the formula because of this?

 

[Charliy]

@day24
IF HOUR({DATETIME FIELD}) < 8
THEN DATE({DATETIME FIELD})-1
ELSE DATE({DATETIME FIELD})

 

[LZido]

Thank you so much - It works!