Any body know of a way to intercept the returns from DATE(), DATETIME(),

TIME() etc. for different timezones WITHOUT changing the Windows setting

for timezone?

We've moved a bunch of applications to the cloud and now have users

accessing from multiple timezones, but the application wasn't built to

handle that. We can't just change the Windows timezone, as that would

confuse the users with their Outlook calendars, or any other time based

applications. There are 5 applications and they would have about 9,000

places each in the code would need to be changed if we have to change the

calls to DATE(), DATETIME(), etc. to use a different function. Most

definitely not looking forward to 45K changes to code!

Thanks for any insight in to this (huge) dilemma.

Fred

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAJCBksrSAfHLHbgaaHA6Htvh8UsD+MMP8xT6X_BuPtDfX2z8gQ@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.