Quote:
Originally Posted by charvi
i getthis dateproble when i enter in the form of mm/dd/yyyy in mskedbox1 though i have formatted maskedbox as dd/mm/yyyy why is it pls help
You need to show us the exact string which is being passed to Access. The fact that the masked edit control shows something in a particular format on the form doesn't tell us anything about what you're getting out of it.
Pretty sure Access demands U.S. date format (MM/DD/YYYY) so the syntax should be something like...
SELECT * From MyTable Where MyDate Between #01/05/2008# And #01/10/2008#
Alternatively, you might avoid the date format issue by using an unambifuous format. That is, one in which the month and day cannot be confused. For example...
SELECT * From MyTable Where MyDate Between #05-Jan-2008# And #10-Jan-2008# 
