Author: Eurico Chagas Filho
Posted: 2012-02-07 at 12:11:48
Fred
You can use a look up reference to make a global change. You could build routines
and make them change places w the build in ones.
I habe been using PEM Editor w success.
E.
>________________________________
> From: Fred Taylor <fbtaylor@gmail.com>
>To: ProFox Email List <profox@leafe.com>
>Sent: Tuesday, February 7, 2012 2:45 PM
>Subject: Re: Any way to alter the time returned by windows for DATETIME()?
>
>Thanks Paul. That may be the route that has to be taken. I'm just not
>that comfortable with that massive a change.
>
>Fred
>
>
>On Tue, Feb 7, 2012 at 9:16 AM, Paul Newton <Paul.Newton@pegasus.co.uk>wrote:
>
>> Fred
>>
>> If you DO have to change the calls I would recommend that you take a look
>> at GoFish available on Codeplex ... you would be able to globally change
>> DateTime( to MyDateTime( etc and then try to achieve what you need in the
>> custom functions MyDateTime(), MyDate(), and MyTime()
>>
>> Paul
>>
>> -----Original Message-----
>> From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com]
>> On Behalf Of Fred Taylor
>> Sent: 07 February 2012 16:07
>> To: profoxtech@leafe.com
>> Subject: Any way to alter the time returned by windows for DATETIME()?
>>
>> 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
>> ---
>>
>[excessive quoting removed by server]
>
>_______________________________________________
>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:
>** 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.
>
>
>
--- 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/1328634708.85375.YahooMailNeo@web160804.mail.bf1.yahoo.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.