I enter a date dd/mm/yyyy in txtCriteria to search for a BuyDate
this works fine in databases in the past, however i now have to enter
the search date as mm/dd/yyyy
BuyDate reads as dd/mm/yyyy and all other dates read as dd/mm/yyyy.
Why has this started to happen.
I have added a new txtCriteria and this did not fix it, i have checked
all daste formats they are correct.
I have checked the code in other databases i have on the same
development system and it correctly finds the date as dd/mm/yyyy.
why or what have i done to this particular database
any help please
Code:
Me![fSubSearchBuyingDetails].Form.Filter = "[BuyingDate] Like #" &
txtCriteria & "#"