TBD or text import to Date Field

Hi All,

I have data that i regularly import that will either be a date, ‘TBD’ and i’m importing into a date field, however it naturally flags the “TBD” entries as invalid, is there a way for the field to allow "TBD’ entry as text or would i be safer changing the field to text to allow the import of both?

Thanks