I'm trying to use the WHERE condition of the docmd.openreport action which requires dates to be in US format (mm/dd/yy). As I and my users are in the UK, the system settings are all UK (dd/mm/yy).
I'm using the following to pass US formatted dates to my WHERE statement:
Format (me.txtFrom, "mm/dd/yy")
but for some reason it only formats to US format if the day part is below 10 (i.e. 06/05/01 (6th May 01) converts fine to 05/06/01, but 26/05/01 (26th May 01) stays as 26/05/01).
Can anyone help me on this, it's driving me nuts!!!!