[AccessD] Filter by Date in XP

Hi Selina

How about forcing a US formatted date-string:

  me.filter = "date_from >= #" & format(MyDateValue,"mm\/dd\/yyyy") & "#"

or wrapping in quotes:

  me.filter = "date_from >= " & Chr(34) & format(MyDateValue,"mm\/dd\/yyyy") & Chr(34) & ""

/gustav

> In 97 & 2K I used :

> me.filter = "date_from >= #" & format(MyDateValue,"d/mmm/yy") & "#"
> me.filteron = true

> But in XP it won't return the correct filter.  Can someone please help.
> Thanks