Page 1 of 1
Date data type in csv export
Posted: Thu Oct 01, 2015 11:35 am
by 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.
Re: Date data type in csv export
Posted: Thu Oct 01, 2015 1:48 pm
by 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.
Re: Date data type in csv export
Posted: Thu Oct 01, 2015 5:23 pm
by 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.
Re: Date data type in csv export
Posted: Fri Oct 02, 2015 11:35 am
by 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