Discuss "date problem in access" in the SQL Development forum.

Hi,


I am using access database and I have a table called Employees

There is a field called Emp_Date the datatype is Text

for example the Emp_Date is like this

09/12/2007


I Have my query like this

I want to display records from latest date to old date

it gives an error

can someone tell me If i am doing the conversion in the right way

todd

it gives an error saying undefined function convert in expression

That should give you the answer. Access doesn't have a function named "convert". When you get such an error message, the first thing you should do is look in the documentation and find out what functions Access has.

BY FAR, the best solution is to always store date information in Date data type fields. If this cannot be done in your situation, then you can use a legitimate Access function like CDate().