S slimjen1 Registered User. Local time Today, 08:49 Joined Jun 13, 2006 Messages 562 May 24, 2013 #1 All, using 2010. I want to query criteria on less than dates. ex. <#3/1/13# but I want the users to be able to put in there own date. I tried <[Enter a date] but returned no values. Please help. Thanks
All, using 2010. I want to query criteria on less than dates. ex. <#3/1/13# but I want the users to be able to put in there own date. I tried <[Enter a date] but returned no values. Please help. Thanks
K kessmiller New member Local time Today, 07:49 Joined Mar 21, 2011 Messages 8 May 24, 2013 #2 SELECT Table1.Field1 FROM Table1 WHERE (((Table1.Field1)<[enter date mm/dd/yyyy])); Table1ID Field1 1 10/15/2012 2 3/1/2012 3 5/15/2013 4 11/1/2013 Is your field defined as date/time? this worked for me. If field is defined as text you'll need different logic. Last edited: May 24, 2013
SELECT Table1.Field1 FROM Table1 WHERE (((Table1.Field1)<[enter date mm/dd/yyyy])); Table1ID Field1 1 10/15/2012 2 3/1/2012 3 5/15/2013 4 11/1/2013 Is your field defined as date/time? this worked for me. If field is defined as text you'll need different logic.
