Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I make part of date field optional?

Status
Not open for further replies.

jlrrush

MIS
Aug 3, 2004
9
US
I have data that may not include complete dates. The month or day may not be known. How can I keep the date/time format but allow the month or date or even the year to stay blank?
For example, 09/_ _/2004 or _ _/_ _/2003
 
If you want to store a date it must be a date. 2003 or September 2003 aren't dates. You need to store separate non-date fields, then you can put what you like in them.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top