Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== 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) tips/revmedia/v2i1a4.txt Last modified: 2024/06/19 20:20by 127.0.0.1