Last post Nov 13, 2008 04:41 PM by Mikesdotnetting
Nov 13, 2008 03:14 AM|rigin|LINK
I have an Access database with the field DATE_Created and its field type is text..
And wan't to query it uses the date input, the date format is d/MM/yyyy
and my current error is
Please Help .. :)
Access database query string
Nov 13, 2008 04:41 PM|Mikesdotnetting|LINK
Change the field to a DATETIME datatype. Then you can run the query you want. Never store dates as text if you want to compare them to eachother, or order them in date order instead of alphabetical order etc.