Hello - I've built a workflow tool for some users here in the US, which is working quite nicely. However, we are now expanding its user base to some offices in Europe and Asia and I've bumped into a problem I'm hoping somebody here can help with.
Part of the workflow requires an update to a sql table, and that update includes the current date. In SQL (MSFT SQL Server Manager), the field is defined simply as a "Date" type.
When the users in our European or Asian offices try to execute that update, SQL rejects it because the formatting is unrecognized. I've tried updating the formats in the front end (Excel) to a US based version (mm/dd/yyyy), but when it sends to SQL, it reverts back to their locale settings.
I've tried changing the SQL field from "Date" to "Varchar" so I can send the dates as a string, but then all of the reports I've built in (which use the month and year date parts) fail.
So ultimately the question is -- is there a way to override the locale settings temporarily? I assume there is some registry setting, but I've not been able to find and manipulate it on my own.
Thank you for any help/guidance!
Bookmarks