WHERE date > n; n = #10/26/2007#

emsik1001 · November 17th, 2007, 10:21 AM

Hi Everyone

I need an SQL statement where a variable will control WHERE clause

For instance

SQLstr = "SELECT * FROM tblJob WHERE Date > #10/26/2007#;" it works

but I want to use a variable instead of the date.

Something like this
n = #10/26/2007#
SQLstr = "SELECT * FROM tblJob WHERE Date > n;"

Is it feasible?

martinrhague · November 17th, 2007, 02:10 PM

Hi

This should work

SQLstr = "SELECT * FROM tblJob WHERE Date > #" & n & "#"

emsik1001 · November 17th, 2007, 03:59 PM

Thanks
:)

SerranoG · November 20th, 2007, 09:00 AM

Actually, since Date() is an Access function, it really should be taken OUTSIDE the quotes, that is...

SQLstr = "SELECT * FROM tblJob WHERE [n] < #" & Date() & "#"

where n is a field in the table. Note: If Date is a field you made up, then change its name. Date() is an Access function, and having a field with the same name will cause problems.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how can i convert date into format '2007-10-25T11:	vishnu108mishra	C#	2	November 23rd, 2007 04:45 AM
Help needed - data from Excel sht where Date>= xx	pandasum	Visual Basic 2005 Basics	0	August 19th, 2007 11:34 PM
want to convert date from 01/12/07 to 12-Jan-2007	hurperl	Perl	1	April 12th, 2007 05:47 AM
Chpt 7 >> Pg 245 >>Try It Out #4-5	harrison4411	BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8	0	March 2nd, 2006 06:26 PM
* where date >= '"& dateVar &"' order by date	wrofox	Classic ASP Databases	5	February 24th, 2005 10:11 AM