Datestamp and group break
I have a table with a timestamp (datetime) field.
I want a group that breaks on the date.
Since in the timestamp field there is a date and a time,
the group breaks on each record since the time is different.
My question : how can I break on a timestamp field but only when
the date changes (so disregard the time)
Thanks aforehand
Lee
I want a group that breaks on the date.
Since in the timestamp field there is a date and a time,
the group breaks on each record since the time is different.
My question : how can I break on a timestamp field but only when
the date changes (so disregard the time)
Thanks aforehand
Lee
This discussion has been closed.
Comments
add a column to the 'Select' clause, fetching only the date portion of the
original column (... in the case your database you are using supports that).
Or you can use the OnGetBreakValue event of the group.
regards,
Chris Ueberall;