Type Mismatch in Expression (in Date Field)

[ameen]

I have a table in Paradox. One of the field has a Date data type. In my application, I supposed to receive the value for this date as a string from a Server in dd/mm/yy format. Before I store the data into my database, I have to check my system date format (whether it is in British format or US Format). After checking, I stored the data. But when I want to filter the record based on the selected date, I am getting an Error with message 'Type Mismatch in expression'. How to avoid this error?.

I would appreciate for any assistance.

Ameen

 

[TealWren]

It could be because dates need to be in quotes. TealWren

 

[BobbaFet]

Have you tried converting the dates to string with:

DateToStr();

Now you can basically just a sort of functionality
like the TFindDialog has. Converting both dates to
string of course. You can basically just bookmark the
matches and filter those out with a query.

BobbaFet Everyone has a right to my opinion.
E-mail me at cwcon@programmer.net

http://cwcon.50megs.com/