gleads
asked on
ADO QUERIES SQL
I am trying to quote dates in the sql of a query, and am wanting to say where mvtdate BETWEEN :DateTo AND :DateFrom
It doesn't like this. I have tried <= and >= but it still doesn't work. Any ideas?
It doesn't like this. I have tried <= and >= but it still doesn't work. Any ideas?
ASKER
What fromat should dates be in in order for the query to work. At the moment, it returns no rows, so I am thinking that with a date e.g. 21/02/2003, it is dividing 21 by 2 by 2003 and therefore not returning any records.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Already solved it a while ago but I will give you the points anyway as I don't know how to remove a question
should work (if it is supported by your database)
can you show, how you do supply the paramaters
meikl ;-)