Tony,
>From my attempts, you could set the DATE format to YYYYMMDD and omit the format in the report. That seems to work when I try it. (Or you could use Bill's method with a variable.) Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of Tony IJntema Sent: Monday, 20 April 2015 11:41 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - RE: How to print 0000000 (yyyymmdd) in TXT report when date is null John, Yes, I have tried both 00000000 and 0. In both cases the result is 18991230 Tony From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of John Docherty Sent: maandag 20 april 2015 13:35 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: How to print 0000000 (yyyymmdd) in TXT report when date is null Tony, Have you tried setting the NULL format in your report to 00000000 for the date field ? Regards, John Docherty From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Tony IJntema Sent: Monday, 20 April 2015 11:27 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - How to print 0000000 (yyyymmdd) in TXT report when date is null Hi, I have to create a TXT report, which contains date values. The format of the date value is yyyymmdd In case the column is null I have to print 00000000 (8 times zero). I have tried to set the null value for this field in the report to 00000000 and also to 0. In both cases the date is printed as 18991230 Has anybody a brainwave for a solution of this problem Tony
