Will do (unless someone else steps up with an existing algorithm).


>Thanks for the info, Rick.
>
>If you get time, I'd appreciate you taking the time to code this.
>
>Thanks a bunch.
>
>Tommy
>
>
>>>Thanks for the info, Rick.
>>>What I want to do is to take a UTC time that was saved in a field, convert it to the Local Time of this PC, and display it on the screen.
>>>e.g.. let's say this field has the UTC time of 09/05/2013 06:46:44 PM
>>>and the user is in North Carolina on this date of 02/12/2014 10:30:00 AM (EST) and wants to display the UTC field value.....
>>>The Local Time for the UTC value would be 09/05/2013 02:46:44 PM (they were on Daylight Savings Time then so the Bias would be -4 hours)
>>>Does MSDN have anything for that?
>>
>>Someone has surely written this in Visual FoxPro already.
>>
>>-----
>>Win32 provides numerous functions to convert back-and-forth generically to any time zone:
>>
>>SystemTimeToTzSpecificLocalTime() in kernel32.dll.
>>http://msdn.microsoft.com/en-us/library/windows/desktop/ms724949%28v=vs.85%29.aspx
>>
>>It's somewhat non-trivial to do it this way using Visual FoxPro. In C/C++ it's much easier. There are several steps involved. Populate the systemtime structures using manual population. You can use GetSystemTime() to populate an empty structure (SPACE(16), GetSystemTime(@lcTime)) to see what it should look like, with what values at what offset. Iterate through the string and extract every two bytes (FOR lnI = 1 TO 16 STEP 2 .... lcThisPart = SUBSTR(lcRawGetSystemTimeData, lnI, 2), and then convert to integer form. You can extract the binary 2-byte integer values from there using BINTOC(,2) and you'll need to store binary integer values back in there using CTOBIN(,2) and STUFF(), or a concatenation in the correct order. Populate the time zone structure using a blank structure (SPACE(88)) and GetTimeZoneInformation(@lcTimezone), and then it will convert using SystemTimeToTzSpecificLocalTime(). Then you extract out the converted form to obtain the new time.
>>
>>I would write this function for you, but I'm a little busy just now. Maybe later if you still need it.
>>
>>>Much appreciated !!!!
>>>Tommy