Query Date Field Type In Access

[Tunde Ajibawo]

How do I query Access Date field, My query returns no records This is my query "Select * from Score where testDate = 3/10/2005"

[Colin Angus Mackay]

I don't know about Access, but I always use the ISO date format YYYY-MM-DD

---

My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

[Edbert P]

AFAIK in Access you use # in between the date, e.g. #3/10/2005# Use the ISO format that Colin mentioned though (#2005-10-03#). Edbert

[Tunde Ajibawo]

Edbert P. wrote: AFAIK in Access you use # in between the date, e.g. #3/10/2005# I try this but still no result Select * from Score where testdate = #2005-03-10# And there is a record with that date

[Edbert P]

Perhaps the date you supplied is in mm/dd/yyyy (U.S.) format instead of dd/mm/yyyy format. Try testing with several dates and combination of dates and see which one gives you a result. Edbert