Newbie Question - "N/A" in a date field?
Sorry for the newbie question but I would like to know if there is a simple way to enter "N/A" in a date field.
I have an inventory database with a date field for Expiration Date. As durable goods do not expire, I would like to enter N/A in the field, but if it is formatted as Date it will not take.
My validation needs oblige me to have all fields entered. My current kludge is to default to 12/31/2050 but I'd like something a little more professional. Leaving ir blank is also not an option.
If this involves complex scripting, some consideration for the learning curve would be much appreciated.