Skip to Content
0
Former Member
Dec 08, 2009 at 02:28 PM

Null Dates change to system default dates upon export to Excel

309 Views

I am using CRXI.

I have a database that has the following fields....

PersonId

Travel=================Yes, No, Unknown===============Did the patient travel in the 7 days before illenss onset?

DestType==============Domestic, International============If yes to travel, what was the destination type?

TravelDestination========List of All Countries and States=====If yes to travel, location?

DtDepart===============MMDDYYYY===================If yes to travel, date of departure?

DtReturn===============MMDDYYYY===================If yes to travel, date of return?

I have created some new formula fields because I only want to display depart/return dates on my report those persons that have traveled internationally.

TravelInt

IF {Case_Lab_Data_New.Travel}="Y"

AND {Case_Lab_Data_New.Dest_Type}="International"

THEN "Yes"

ELSE IF {Case_Lab_Data_New.Travel}="Y"

AND {Case_Lab_Data_New.Dest_Type}="Domestic"

THEN "No"

ELSE IF {Case_Lab_Data_New.Travel}="N"

THEN "No"

ELSE "Unknown"

DtUSDepart

IF {@TravelInt}="Yes"

THEN {Case_Lab_Data_New.DtDepart}

DtUSReturn

IF {@TravelInt}="Yes"

THEN {Case_Lab_Data_New.DtReturn}

Both of these formulas for the Dates have the Option "Exceptions for Nulls" selected. On the screen, the formulas only return date values for those persons that traveled internationally (which is what I want to happen). However when I export the data to Excel, I have system default dates where the null values should be (01/00/1900). Do you guys have any suggestions as to how to fix this? I can't figure out what I am doing wrong.

Thanks in advance,

Amanda