Should I use dates in quotes or without quotes?
Using text date type, the only comparison you can make in a query is =. To work with a range (>, < or between dates) your queries are going to need calculated fields to convert the text to a date value (in the query only, not converting the actual table data). You might want to consider having a new table field on which you run an update query to convert the text values to dates. I don't like the idea a whole lot, preferring to have the original data as dates, but I suspect you'd say that's not possible because of where it comes from.[/quote]
If it is text field then how come is sorting date according to query ?
This I don't understand.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.