SQL date help

[Newsgroup_User]

Using Access...

I need to "select * from tablename where datefield >= date()"

This throws an error, can you help with syntax?

[Newsgroup_User]

http://office.microsoft.com/en-au/assistance/HA010546621033.aspx

Should help. I'll drop by in a moment when I have more time.

I'm assuming you're using ASP?

I'm not sure how the two formats correlate, but like i said will check back
in a few when i wake up more.