I am using Xbase++ and List & Label 14.
Since upgrading to version 14 from version 12, I have noticed that L&L seems to format a date incorrectly if the date value is empty. If I assign the empty date value to a variable within L&L, it prints a really weird value (example: -7/-15/-18311).
If I put the value within the Date$() function, I get a different incorrect value (example: 4.29e+009).
I tried putting the date within the NullSafe() method, but that didn’t help.
I was able to get around the problem by using the following formula for the date value within my report:
If(Year(PO.ETA_DATE) > 0, Date$(PO.ETA_DATE), ’ ')
Still, I would prefer not to have to put this code around every date value in my reports. I don’t remember L&L having issues with empty date values in version 12.
The empty date values I am trying to print are stored in .DBF tables. I am using Advantage Database Server version 9.1.
Has anyone else experienced a similar problem? Is there a setting I can change with the report that would render empty date values correctly?
Any help will be appreciated. Thanks!