I am using 2 SQL instances, one is remote on the server and one local on my machine. Both instances have British date format settings, but one performs different to another. I am calling a function in SQL Server from Access VBA.
For example, when I pass a date to a local instance in this format #31/03/2011# it doesn't work, although the date settings is British.
But when I pass to remote instance works fine on both formats, #31/03/2011# and #03/31/2011# also the date settings is British.
I dont' understand why this happening.
Can I also ask how to pass a date from MS Access VBA to SQL Server 2008 R2 in this format: yyyymmdd ? As I thought the format is universal within SQL Server and should interpret dates regardless on settings.
View Complete Post