Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Datestamp and group break

edited July 2001 in General
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

Comments

  • edited July 2001
    Hi Francois,

    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;
This discussion has been closed.