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...
- 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'?
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'?
