By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

How do I Show TBA When Date is Null

P: 1
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.
Jan 13 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,492
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 :
Expand|Select|Wrap|Line Numbers
  1. 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.
Jan 13 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.