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.
Date fields must either be valid dates or null I wouldn't convert all dates to text values as that will cause other issues e.g. sorting by date field in queries. Would using something like #1/1/9999# be an acceptable alternative for 'Life'?
Date fields must either be valid dates or null I wouldn't convert all dates to text values as that will cause other issues e.g. sorting by date field in queries. Would using something like #1/1/9999# be an acceptable alternative for 'Life'?
