query sql office 2007 HELP

G

genna.marcello

Hi,
i have a little problem: i have 1 table

table(id,from,to,idEXT)

where from and id are DATE/TIME

I execute the query, with function "query design":

SELECT * FROM table WHERE from>#dd/mm/yyyy# or from>#dd/mm/yyyy#

The question is: because sometime the result is correct? The format
#dd/mm/yyyy# is correct?

Help me!

Tankyou!

Marcello
 
Top