date field
1 Topic
How to handle indefinite date
Hey Microsoft Community, I have a date field and one of the possible values is "Life" as in "for life". Is there a way to convert the text "Life" into a date value that is indefinite? Or should I just convert all the date values into short text, use an input mask and store it that way? I am very new to access so as always thank you for your input. I look forward to working with you in solving this problem. Sincerely, EbSolved1.8KViews0likes3Comments