1
1robc57
Access 2007.
Applying a DateFilter to a Date/Time field in a table. If all dates are > 2
years from Now, only get 6 DateFilter choices (Equals, DoesNotEqual, Before,
After, Between, AllDatesInPeriod). Make any date in field < 2 years from Now
and get 24 choices (above 6 + week, month, quarter, year, etc.).
Why the 2 year range? Is this ByDesign or Bug?
Applying a DateFilter to a Date/Time field in a table. If all dates are > 2
years from Now, only get 6 DateFilter choices (Equals, DoesNotEqual, Before,
After, Between, AllDatesInPeriod). Make any date in field < 2 years from Now
and get 24 choices (above 6 + week, month, quarter, year, etc.).
Why the 2 year range? Is this ByDesign or Bug?