Date data type in csv export

[rkas400]

We have date data types in our subfiles with csv export enabled. When we export and date is null, xl has 0001-01-01. Is there anyway to make the cell blank on a null date?

Thank you.

[Scott Klement]

Is this a database-driven subfile? or one that you are loading from RPG?

Display files don't have the concept of "null", but if this is database-driven you could use SQL's IFNULL or COALESCE to map nulls to blanks.

If this is RPG driven, your RPG program could check if the field is null and send blanks to the display.

When the field is displayed on the screen, does it show up as blank? Or as 0001-01-01? The CSV should match what is on the display.

[rkas400]

subfile is loaded through the rpg program and I am clearing the subfile field if field in file is null. On the subfile I am seeing a blank field. But the xl cell shows 0001-01-01.

[Scott Klement]

Can you please post a JSON dump? To do this, navigate so that your subfile with the blank dates is on the display. Then, press Ctrl-F9 -- it will ask to download a file named json.txt -- this is the file I need.

Either attach it to a message here, or e-mail it to support@profoundlogic.com