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