Group by time intervals

[tdpeasb8]

I am working on a report where the data is in 15 minute increments. I have an example report that rolls the data up in 1 hour totals. It looks like:
GroupByHour
Time(Hour({FORECASTTIMESERIES.DATETIME}),00,00);
When its used in formulas it is used as @GroupByHour.

I want to change it from an hour to half hour groupings but can't figure how to say group on if minutes = 00 or 30.
Thank you

 

[synapsevampire]

Here's the CD link to the solution:

http://support.crystaldecisions.com/library/kbase/articles/c2005347.asp

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[tdpeasb8]

Looks like this will do the trick.
Thank you