Andrew Fergus
MrExcel MVP
- Joined
- Sep 9, 2004
- Messages
- 5,462
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Hi everyone
I'm having one of those days where I can't see what I have done wrong but I cannot get this to work.
My VBA script is viewing the date critieria from a form in US format (i.e. mm/dd/yy) when my PC, table, form, query & report have everything set to the international format (dd/mm/yy) using the 'Short Date' option. For example, where I enter a date 01/12/05 (Dec 12th) into an unbound text box, I think the VBA script is reading it as 12/01/05.
Consequently, the script is returning the incorrect records based on the different date format.
Does anyone have any suggestions?
TIA, Andrew
I'm having one of those days where I can't see what I have done wrong but I cannot get this to work.
My VBA script is viewing the date critieria from a form in US format (i.e. mm/dd/yy) when my PC, table, form, query & report have everything set to the international format (dd/mm/yy) using the 'Short Date' option. For example, where I enter a date 01/12/05 (Dec 12th) into an unbound text box, I think the VBA script is reading it as 12/01/05.
Consequently, the script is returning the incorrect records based on the different date format.
Does anyone have any suggestions?
TIA, Andrew