Filter Report By Date

  • Thread starter Edgar Chado via AccessMonster.com
  • 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.
 
O

Ofer

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
 
E

Edgar Chado via AccessMonster.com

Ofer,

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

Edgarchado
 
Top