By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,478 Members | 1,501 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,478 IT Pros & Developers. It's quick & easy.

Filtering forms by date

P: 10
Hello everyone,
I was wondering if it is possible to filter a form in access by date when the populated field on the form is the date (i.e. dd/mm/yyyy).If this is possible I was wondering what the code for doing this might look like.
Dec 30 '11 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,709
Example Filtering on a Form includes all you need for filtering by dates. Remember though, that dates can be particularly fiddly and it may well be necessary for you to spend time reading and understanding the Literal DateTimes and Their Delimiters (#) article linked within to help you understand why the date-related code is as it is. Unbound controls that contain dates as values are still only string values. Only where they are bound to Date type fields may they be assumed to be treated as dates.
Dec 30 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.