Exporting blanks to excel

Exporting blanks to excel

  
Hello Everybody,
I am exporting the results of an advance query into Excel.  When the date field is null, I want to export blanks into the cells of the excel spreadsheet........not the default '1900-01-01 00:00:00:00:000'
How do I do that in the advance query?  I have tried Nullif(startdate, '') and I have tried isnull(startdate, '') to no avail.
Thanks in advance.
Frank


i assume you are trying to validate if the date is initial?

try: "IF(datevar = NullDate(), "", datevar)"

where obviously the destination variable/structure would have to be text-type
Declaring the varable/struct a text field did the trick!!!  I would have never guessed that.