Forum Discussion
Solved
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,
Eb
- 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'?
3 Replies
- 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'?
