chucher wrote:
I'm trying to put a filter into some forms or filters but the filter
donīt work properly.
I'm using the format dd-mm-yyyy. The forms and the tables always shows
how dates in that format. But when i put filters i donīt get the
expected res result in fact some times i donīt get any result.
I al ready try this filters
date = #08/05/2006#
date <= #08/05/2006#
date between #07/05/2006# and #09/05/2006#
i al ready try use # format(08/05/2006, "dd-mm-yyyy") # in each
filter and still don't work.
I hope you can help me
thanx
Date literals in Access queries/filters must use US format, ISO format, or an
unambiguous format where the month uses alpha characters. Your regional
settings and internal format settings do not matter.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com