Tony,
I tried printing a null date with no format set for the date field and I got the 000000, but when I put in a format I get the number as you did. 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
