Applyfilter problem

[MrM121]

Does anyone know how to do a date search (single date and range) when the format of the date is dd/mm/yyyy (UK date format). Whenever I enclose the date in #, the date is converted to US style, and so does not correctly filter the form.

Thanks

 

[PHV]

Simply use the Format function:
Me.Filter = "[field date]=#" & Format(Me![control date], "m/d/yyyy") & "#"
Same sort of thing for range:
Me.Filter = "[field date] Between #" & Format(Me![control startdate], "m/d/yyyy") & "# And #" & Format(Me![control enddate], "m/d/yyyy") & "#"


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MrM121]

Thanks for that. In the end I had already done that, but I wasn't too sure if there was another way around it. I noticed that was happening with the query, but wasn't too sure what the function was to convert it.

Cheers,

Nick