edgarchado
Technical User
Hi,
I 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?
Thanks.
I 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?
Thanks.