upobDaPlaya
asked on
How do you convert 31/12/2011 to 12/31/2011
I have a SQL statement that I run in MS Access 2010 with a WHERE clause on the date. The date is passed into the module in the format of 31/12/2011, however I need it to be in the format of 12/31/2011.
How do I cahnge the value to 12/31/2011 prior to running the SQL ?
How do I cahnge the value to 12/31/2011 prior to running the SQL ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
HainKurt,
Yeah, that was just a shot in the dark...
...wanted to see if it would work without breaking up the date...
Jeff
Yeah, that was just a shot in the dark...
...wanted to see if it would work without breaking up the date...
Jeff
ASKER
One important variable I left out is that my PC is set to European Format for the regional settings and for the purpose of other work I need to keep it that way..is there a way within VBA to programatically change my settings to US prior to importing my data that contains the dates into my Access table.
The flow is the date values are imported into MS Access via a MS Acess module from MS Excel. After the import is completed I run my SQL which has a WHERE clause on the date value.
If not I will try the mid,left,right combo.
The flow is the date values are imported into MS Access via a MS Acess module from MS Excel. After the import is completed I run my SQL which has a WHERE clause on the date value.
If not I will try the mid,left,right combo.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
where mycol = mid(param,4,5) & "/" & left(param,2) & "/" & right(param, 4)