I've managed to progress my earlier problem but have again hit a problem. The WHERE condition of the docmd.openreport action 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!!!!
Muttley
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!!!!
Muttley
