OK - thanks for the reply - I already posted a link to a win API call
for getting the time zone (and saving flag).
AndyD 8-)₹
On 19:59, Dan Covill wrote:
On 02/10/12 01:17, AndyD wrote:
I assume this is some sort of time-stamp stored in a dbf so how are you
suggesting the UTC is saved?
I assume this is some sort of time-stamp stored in a dbf so how are you
suggesting the UTC is saved? (DateTime does not recognise time zone or
milliseconds according to Help! )
AndyD 8-)₹
On 19:59, Dan Covill wrote:
snip
I'm with Ed, any solution has to start with saving the UTC. And don't
On 02/10/12 01:17, AndyD wrote:
I assume this is some sort of time-stamp stored in a dbf so how are you
suggesting the UTC is saved? (DateTime does not recognise time zone or
milliseconds according to Help! )
AndyD 8-)₹
No, the UTC (Universal Time, Coordinated) is just a date or date/time
If programming was easy, everybody would be doing it.
From: Dan Covill dcov...@san.rr.com
To: ProFox Email List profox@leafe.com
Sent: Wednesday, February 8, 2012 7:32 PM
Subject: Re: Any way to alter the time returned by windows for DATETIME()?
On 02/08/12
Seconded on the UTC front. worth biting the bullet on day one as it makes
things a whole lot easier!
Dave
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of
Dan Covill
Sent: 09 February 2012 00:32
To: ProFox Email List
Subject: Re: Any
To get the users' local time zone for your mydatetime() pinch some code
from:
http://support.microsoft.com/kb/194576
AndyD 8-)#
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free
That will come in handy, thanks!
But getting the user's local time is not the problem, it's posting things
according to the application's time that's the issue. Kind of hard to
explain (hard enough keeping it straight in my head!) with all the
different app requirements, users from multiple
On Wed, Feb 8, 2012 at 10:42 AM, Fred Taylor fbtay...@gmail.com wrote:
That will come in handy, thanks!
But getting the user's local time is not the problem, it's posting things
according to the application's time that's the issue. Kind of hard to
explain (hard enough keeping it straight in
Would be nice to have such things as columns to handle this. These
applications are way too old to put that much effort into it.
They're all getting replaced soon (ha!) with a .NET web app (3+ years late
already).
Fred
On Wed, Feb 8, 2012 at 10:02 AM, Stephen Russell
On Wed, Feb 8, 2012 at 11:07 AM, Fred Taylor fbtay...@gmail.com wrote:
Would be nice to have such things as columns to handle this. These
applications are way too old to put that much effort into it.
They're all getting replaced soon (ha!) with a .NET web app (3+ years late
already).
On Feb 8, 2012, at 10:42 AM, Fred Taylor wrote:
But getting the user's local time is not the problem, it's posting things
according to the application's time that's the issue. Kind of hard to
explain (hard enough keeping it straight in my head!) with all the
different app requirements, users
On Wed, Feb 8, 2012 at 11:17 AM, Ed Leafe e...@leafe.com wrote:
On Feb 8, 2012, at 10:42 AM, Fred Taylor wrote:
But getting the user's local time is not the problem, it's posting things
according to the application's time that's the issue. Kind of hard to
explain (hard enough keeping it
On Wed, Feb 8, 2012 at 10:17 AM, Ed Leafe e...@leafe.com wrote:
On Feb 8, 2012, at 10:42 AM, Fred Taylor wrote:
But getting the user's local time is not the problem, it's posting things
according to the application's time that's the issue. Kind of hard to
explain (hard enough keeping it
On Wed, Feb 8, 2012 at 10:15 AM, Stephen Russell srussell...@gmail.comwrote:
On Wed, Feb 8, 2012 at 11:07 AM, Fred Taylor fbtay...@gmail.com wrote:
Would be nice to have such things as columns to handle this. These
applications are way too old to put that much effort into it.
They're
On Feb 8, 2012, at 11:23 AM, Fred Taylor wrote:
Ed I agree 1000%. But these apps were originally developed 18 years ago.
No reason to think of such things then. It's amazing they were even Y2K
compliant!
Time zones existed 18 years ago! :)
What I'm saying is that as you
On Wed, Feb 8, 2012 at 10:28 AM, Ed Leafe e...@leafe.com wrote:
On Feb 8, 2012, at 11:23 AM, Fred Taylor wrote:
Ed I agree 1000%. But these apps were originally developed 18 years ago.
No reason to think of such things then. It's amazing they were even Y2K
compliant!
Time
On Wed, Feb 8, 2012 at 11:45 AM, Fred Taylor fbtay...@gmail.com wrote:
Time zones existed back then, but the app and the users were only in one.
Even when the user base expanded, the app still only ran in one place, and
the far flung users ran it using remote desktop. They still had their
Fred Taylor wrote:
snip
All the clever ideas were immediately trashed soon after their suggestion.
Some of those were even my ideas! g
Fred
Could you not go back to using a TS connection even though the data is
now in the cloud? That would buy you some time.
Peter
We receive various formatted dates/times from all over. Times were noted
as to their source and converted as needed to the local time of the app.
The problem now is that the app is seeing multiple local times, which it
never did before. This app existed the way it is long before I got here.
On 02/08/12 09:45, Fred Taylor wrote:
We're discussing the options this afternoon. But as with all things in the
programming world, the fix is needed yesterday!
All the clever ideas were immediately trashed soon after their suggestion.
Some of those were even my ideas!g
Fred
Hi, Fred
I
On Wed, Feb 8, 2012 at 5:32 PM, Dan Covill dcov...@san.rr.com wrote:
On 02/08/12 09:45, Fred Taylor wrote:
We're discussing the options this afternoon. But as with all things in
the
programming world, the fix is needed yesterday!
All the clever ideas were immediately trashed soon after
On Tue, Feb 7, 2012 at 10:06 AM, Fred Taylor fbtay...@gmail.com wrote:
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
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
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.new...@pegasus.co.ukwrote:
Fred
If you DO have to change the calls I would recommend that you take a look
at GoFish
Fred Taylor wrote on 2012-02-07:
Thanks Paul. That may be the route that has to be taken. I'm just not
that comfortable with that massive a change.
Fred
We've moved a bunch of applications to the cloud and now have users
accessing from multiple timezones, but the application wasn't
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 fbtay...@gmail.com
To: ProFox Email List profox@leafe.com
On 2/7/12 8:06 AM, Fred Taylor wrote:
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!
Automated changes, not manual, right? There are tools for that.
Paul
Absolutely.
Fred
On Tue, Feb 7, 2012 at 10:28 AM, Paul McNett p...@ulmcnett.com wrote:
On 2/7/12 8:06 AM, Fred Taylor wrote:
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!
Automated
It's just plain old VFP updating tables. The problem is that a user from
EST zone stamps a record at say 11:00 AM local time. A user from PST
stamps a record at 10:00 AM local time (1:00 PM EST). The 10:00 AM time is
in the change queue as before the 11 AM entry, even though it occurred
later.
Thanks Eurico, that looks like what's got to be done a mass change. Code
is being written to handle an offset to the VFP local time to make
everything consistent again.
Fred
On Tue, Feb 7, 2012 at 10:11 AM, Eurico Chagas Filho e28cha...@yahoo.com.br
wrote:
Fred
You can use a look up
Fred Taylor wrote on 2012-02-07:
Thanks Eurico, that looks like what's got to be done a mass change. Code
is being written to handle an offset to the VFP local time to make
everything consistent again.
Fred
Fred,
I found some code a few years back on the foxwiki to determine UTC
On 2/7/2012 1:34 PM, Fred Taylor wrote:
It's just plain old VFP updating tables. The problem is that a user from
EST zone stamps a record at say 11:00 AM local time. A user from PST
stamps a record at 10:00 AM local time (1:00 PM EST). The 10:00 AM time is
in the change queue as before the
I handle times from all round the world. Everything is saved in UTC (GMT) so
there can be no problems.
Allen
-Original Message-
From: Fred Taylor
Sent: Tuesday, February 07, 2012 7:36 PM
To: profoxt...@leafe.com
Subject: Re: Any way to alter the time returned by windows for DATETIME()?
On Tue, Feb 7, 2012 at 12:42 PM, Tracy Pearson tr...@powerchurch.comwrote:
Fred Taylor wrote on 2012-02-07:
Thanks Eurico, that looks like what's got to be done a mass change.
Code
is being written to handle an offset to the VFP local time to make
everything consistent again.
If only they had thought of that 18 years ago when the apps were first
written.[?]
Fred
On Tue, Feb 7, 2012 at 12:55 PM, Allen pro...@gatwicksoftware.com wrote:
I handle times from all round the world. Everything is saved in UTC (GMT)
so
there can be no problems.
Allen
-Original
No, the only thing is that all postings be for the same timezone. That
will solve the issues for now.
Fred
On Tue, Feb 7, 2012 at 12:48 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
On 2/7/2012 1:34 PM, Fred Taylor wrote:
It's just plain old VFP
Airlines have been doing it that long, well I think so. I will ask a friend
who knows.
Al
-Original Message-
From: Fred Taylor
Sent: Tuesday, February 07, 2012 9:01 PM
To: profoxt...@leafe.com
Subject: Re: Any way to alter the time returned by windows for DATETIME()?
If only they had
do you use a HTML/JS user interface?
If so you could add some JS on form.submit() to convert date and time to
UTC, and do the other way round when response comes in.
this way you would have consistent UTC dates on your back end
Thierry Nivelet
FoxInCloud
Give your VFP app. a new life in the
All stock VFP. No html/js.
Fred
On Tue, Feb 7, 2012 at 1:27 PM, Thierry Nivelet tnive...@foxincloud.comwrote:
do you use a HTML/JS user interface?
If so you could add some JS on form.submit() to convert date and time to
UTC, and do the other way round when response comes in.
this way you
Most of the replacements should be fixed with an easy
#define date mydate
#define datetime mydatetime
This wouldn't affect any dynamically created code, though.
Christof
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Hi Christof,
I thought of doing that, but can you use #DEFINE in a report? The biggest
problem I see with #DEFINE would be making sure all the code was covered,
especially in the screens/classes.
Not sure if there's any dynamic code with those functions.
Fred
On Tue, Feb 7, 2012 at 11:26 PM,
41 matches
Mail list logo