Im running a query thorugh code but its not working. I think I know why its not working but dont know how to get it to work
Im querying date fields and its not working....however if I make an actual query, and enter the dates in the condition fields in the following format
the query works
When I look at the sql code of the query, the date fields are changed to
The format I have the dates in is dd/mm/yyyy...........how can I get my manual query to work?
Also, I have checked the table design and it is set to short date (dd/mm/yyyy)????