Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting time on specific time zones
Message
From
11/10/2000 01:46:08
 
 
To
11/10/2000 01:39:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00427695
Message ID:
00427713
Views:
17
>Using the top frame as an example, each message ends with a TTOC(DateTime). You could store an hours difference for each user (e.g. Pacific Time = Montreal Time - 3hours).
>
>So, Al Doman would get TTOC(DateTime + (3600 * Hours Difference))

Interesting, I never thought of using the seconds to obtain the new value.

My approach was to use something like this:
LOCAL lcTime,lnOffSet,ldDate,lnHour
ldDate=CTOD(DTOC(tdTime))
lnOffSet=gnTimeZone-8
lnHour=HOUR(tdTime)+lnOffSet
IF lnHour<0
   lnHour=24-ABS(lnHour)
   ldDate=ldDate-1
ENDIF
IF lnHour>23
   lnHour=lnHour-24
   ldDate=ldDate+1
ENDIF
where gnTimeZone is based on a number from 1 to 24 based on the list you see in the account setup for PUTM features on the time zone field.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform