I have a form where, a user enters a date and the form can return one of 3 values, determined from data in another table using a DLookUP.
The data in the table has one date (the date where the season type begins) followed by the season.
Is it possible to have it stored as a date range so that the formula looks at the date and goes down to the start date one lower, then returns the season?