QTIPS - Break-On Date Fields
Published By | Date | Version | Knowledge Level | Keywords |
---|---|---|---|---|
Sprezzatura Ltd | 01 MAY 1990 | 1.15+ | EXPERT | BREAK-ON, DATE |
When breaking on a value such as a date, it is frequently desirable to include the date in the heading rather than display it for every record listed. This would normally be achieved using a syntax similar to
LIST TIME_SHEETS BY DATE BREAK-ON DATE "'B'" HEADING "'B'"
Unfortunately this results in the date in INTERNAL format being displayed in the heading. To get round thus create a symbolic dictionary item (eg DS) with a display length of 0 and a formula similar to
@ANS = {DATE} "D2/E"
and change the list statement to be
LIST TIME_SHEETS BY DATE BREAK-ON DS "'B'" HEADING "'B'"
(Volume 2, Issue 1, Page 7)