Hi,
I'm looping through a couple of recordsets to check if there are clashes. I compare the recordset date field against on other date.
the simplified explaination for this strange thing i'm expericiencing is as follows:
if rstDate > Date then .....
having rstDate = 13 / 1 / 2005 checked against Date = 15 / 1 / 2005 works fine (no "then" action initiated.
But, having rstDate = 1 / 5 / 2005 checked against Date = 15 / 1 / 2005 triggers the "then" action.
I understand that the problem has something to do with the data format. Case one access sees dd-mm-yyy while in case two, access sees mm-dd-yy
Could someone advise a solution on this please?
Thanks
Patrick
I'm looping through a couple of recordsets to check if there are clashes. I compare the recordset date field against on other date.
the simplified explaination for this strange thing i'm expericiencing is as follows:
if rstDate > Date then .....
having rstDate = 13 / 1 / 2005 checked against Date = 15 / 1 / 2005 works fine (no "then" action initiated.
But, having rstDate = 1 / 5 / 2005 checked against Date = 15 / 1 / 2005 triggers the "then" action.
I understand that the problem has something to do with the data format. Case one access sees dd-mm-yyy while in case two, access sees mm-dd-yy
Could someone advise a solution on this please?
Thanks
Patrick