My data source is a spreadsheet extract. There are two fields with date values.
The first, "Scheduled Date", contains only date values. Crystal Reports recognizes this data type as DateTime (which is perfect).
The second, "Actual Date", contains date values and "TBD" values. Changing these TBD values in the data source is not an option. Crystal Reports recognizes this data type as String (I want DateTime).
I would like to change the Actual Date field data type to DateTime so I can compare the two dates in a formula (if Actual Date > Scheduled Date .... etc.).