Date comparison problem

[green'n'white]

hi,

Using asp I am attempting to select the next record from my access db where the date is after today but cannot seem to get it right, i keep getting different error messages.

If the query is something like;

"SELECT TOP 1 games.date, games.opposition, games.venue FROM games WHERE the game date is after today ;"

By the way the date format in the db in dd/mm/yyyy, not sure if this is part of the reason for my failure.

Thanks in advance.

[russell]

SELECT TOP 1 [date], opposition, venue
FROM games
WHERE [date] > Date()
ORDER BY
[date] ASC

[green'n'white]

Thanks Russel,

Worked a treat