I'm having trouble with a couple of fields from a "linked table".
The field names are "Actual Start" and "Actual Finish".
The fields are supposed to be date fields but if a record does not have a date a "NA" appears. This "NA" seems to override the Date\Time type and forces the field to a "Text" field.
I've attached a DB with an example table (in the real world this table is a linked table that I can't change).
Is there a way to configure a query to get rid of the "NAs" so that the fields can be exported out as a Date/Time field?