Grouping based upon datetime?

Dave A. Law

I'm evaluating this product and I was wondering if it was possible to group data based upon date time. What I'm looking to do is to break data into "days" but these days start at 8AM, so I want from 8AM one day to 8AM the next day, etc. Is this possible? How would I do it?

Dave A. Law
Software Developer
NuFlo Measurement Systems

gordk

normally one sets the condition property of the group header.
this expression can be based on frfunctions and variable values
However, since your time span is covering 2 partial periods, it may not be acheivable and should probably be resolved at the data entry level, by adding 2 fields to the underlying table. ie curyear and period and sort the table on those fields. period of type integer can be 1 to 366 and after decoding original tdatetime
value into day of year, and year, check time range to set the period value and curyear value.
If you have some sample data available post it in the binaries news group
and ill take a look.

kevin475

Maybe you could use a function that subtracts 8 hours from the DateTime before it extracts the date?

- Kevin