Strangely, it is. Sort of.
I was just preparing to respond with a simple "
No.", when I realised that, although you cannot store "TBD" in a Date field, you can still show TBD in the format should the field be Null.
I don't know your default date format, but if I assume it is a standard US short date format of mm/dd/yyyy, then the format to use for your date field would be :
- mm/dd/yyyy;mm/dd/yyyy;mm/dd/yyyy;TBD
NB. The four fields (separated by semi-colons (;)) in the format string correspond to :
- Positive numbers (Dates after 12/30/1899).
- Negative numbers (Dates before 12/30/1899).
- Zero (12/30/1899).
- Null
It is important to understand with formatting that this doesn't effect the underlying data at all. The value stored is still Null, and no text is stored in your Date field. TBA is only
displayed when the value is Null.