In order for this site to work correctly, and for us to improve the site, we need to store a small file (called a cookie) on your computer.
By continuing to use this website, you agree to our cookies and privacy policy.
  
Home page Home page Home page Home page
Pixel
Pixel Header R1 C1 Pixel
Pixel Header R2 C1 Pixel
Pixel Header R3 C1 Pixel
Pixel

QTIPS - Break-On Date Fields

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


0001       @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)
Pixel
Pixel Footer R1 C1 Pixel
Pixel
Pixel
Pixel