Filter Report By Date

  • Thread starter Thread starter Edgar Chado via AccessMonster.com
  • Start date Start date
E

Edgar Chado via AccessMonster.com

am using a form to filter a report by different criteria. These are a
Order ID (number), Date (date) and Client (string). I have no problem when
filtering by client and Order Id, but I do have a problem with the date. I
do not use the american format for dates (mm/dd/yyy), instead I use
dd/mm/yyyy.

The problem is that the filter is using the american format, but I need to
use the other format.

I am using this code for sending the date filter to the report:

Case 1 ' Date
strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] = #" & Me
("Filter" & intCounter) & "# And

Should I change anything? Is it the form or the report?

Thanks.
 
So try and change both side format, so what ever format you get it you will
change both side to what you want

strSQL = strSQL & "format([" & Me("Filter" & intCounter).Tag &
"]),'dd/mm/yyýy' = #" & format(Me("Filter" & intCounter),"dd/mm/yyyy") & "#
And
 
Ofer,

Thanks for the help. It was what I was looking for.

Edgarchado
 
Back
Top