Current Date in SQL Query

[dungstar]

This seems like a straight forward function but I don't quite know how to call the current date function in the Access SQL query.

SELECT *
FROM table
WHERE sysdate BETWEEN '4/30/02' AND '5/1/03'

(sysdate: the current date function (Oracle current date))

TIA,
D

 

[dungstar]

I am fairly familiar with Access SQL. I know the date function for VB, but I was just wondering if there is one for Access SQL it self. If not, I guess I'll have to use VBA to support it.

Thanks, Pat.

Yes, Seattle's my favorite city as well, I've been all over to place and this is the place I will always call home. =) How are you liking working at Boeing?

 

[dungstar]

You're right, Pat. This was easy enough. All I had to do was use the Date() function in the where clause.

SELECT *
FROM table
WHERE Date() BETWEEN '4/30/02' AND '5/1/03'

 

[dungstar]

Thanks for correcting my syntax, Pat. I'm actually using form control objects as the date variables.