How do I Show TBA When Date is Null

[MRKRZ2]

Is it possible make a column a date field but if a date is not known that "TBD" can be entered in the same date field? The field needs to be a date and/or text field.

[NeoPa]

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 :

1. Positive numbers (Dates after 12/30/1899).
2. Negative numbers (Dates before 12/30/1899).
3. Zero (12/30/1899).
4. 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.