Change 24h day interval in group field

[gorfan]

Hi,
I'm using Visual Studio Net 2003.

I have a report that displays shifts on a per month basis.
I use a Group Name Field that sorts and prints the shifts
for every day.

My problem is "my working day" is between 08:00 until 08:00 next day, instead of the default 00:00 to 00:00.
Is there a way to do this?

Possibly using a "formula as group Name" ?

Thanks in advance

 

[lbass]

Assuming that you treat times between midnight and 8 a.m. as belonging to the previous day, then you could create a formula like:

if time({table.datetime}) in time(0,0,0) to time(7,59,59) then {table.datetime}-1 else {table.datetime}

Then group on this formula.

-LB