DateFilters for Date/Time field change based on age of dates - Why

1robc57

Guest

Posts: n/a

4th Mar 2008

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?

« Using a table as query parameters / create six tables out of two | IIF Syntax error »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: change date based on time	kdp145	Microsoft Excel Misc	1	14th Dec 2005 02:05 AM
Re: change date based on time	Myrna Larson	Microsoft Excel Misc	2	13th Dec 2005 06:08 PM
Re: change date based on time	kdp145	Microsoft Excel Misc	0	13th Dec 2005 02:46 PM
Re: change date based on time	ScottO	Microsoft Excel Misc	0	13th Dec 2005 05:29 AM
DIW record filtering (based on date/time field)	Thanasis \(sch\)	Microsoft Frontpage	1	14th Jan 2005 06:10 PM