DataView.RowFilter using Dates

[pendragon]

Hi all

 

What I am trying to do is filter some data by Date, trouble is that the rowfilter will only take the date in US format and will not use my local settings that being UK.

 

If i am doing an SQL statement to get data by date I can use the DateValue('') funtion to ensure that it use's my settings, is there something that I can use in the rowfilter command or have I not set something up right??.

 

Thanks.