Bill,
That does he trick. It works like a charm Thank yoy for helping me. Tony From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: maandag 20 april 2015 13:53 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: How to print 0000000 (yyyymmdd) in TXT report whendate is null Tony, Print a variable set to (IFNULL(datecolumn,'00000000',format(datecolumn,'YYYYMMDD'))) Bill On Mon, Apr 20, 2015 at 7:27 AM, Tony IJntema <[email protected]> wrote: 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
