Filter Report By Date

[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.

 

[Guest]

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

 

[Edgar Chado via AccessMonster.com]

Ofer,

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

Edgarchado