Thanks for the reply....
The application will be used in different languages. The user input date will be in the standard format 12-Apr-2013.
If the language settings are other than English, DateValue function gives an error message else it provides me Date in the format I need.
I don't...
I have a table in access database which contains a text field 'EDate' that stores Date value in format (12-Apr-2013). Now I want to run a sql query on that field. User will give an input date. The sql query needs to fetch me all the records from access database whose Edate is less than or equal...