6 Replies Latest reply on Aug 8, 2014 11:37 AM by HankB.

    Newbie Question - "N/A" in a date field?

    HankB.

      Title

      Newbie Question - "N/A" in a date field?

      Post

           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.

            

           Thanks.