Unix DateTime to VFP DateTime

#1

Been fussing with this a while and am stuck Could really use code sample.

I have a Unix time value of 1081954800 which actually translates to Wed, 14
Apr 2004 15:00:00 UTC.

Using Excel I can get it to convert by this formula:
=UnixValue/86400+"1/1/70"
then formatting as date...

but VFP has no way of converting the resulting serial number (38091.625) to
a DateTime value like Excel....or does it?

Any help is appreciated, in a pinch so may cross post apologize in advance.

#2

Nevermind I got it.

"Confused" <Sorry (AT) TooManyViruses (DOT) com> wrote

Quote:

Been fussing with this a while and am stuck Could really use code sample.

I have a Unix time value of 1081954800 which actually translates to Wed,
14
Apr 2004 15:00:00 UTC.

Using Excel I can get it to convert by this formula:
=UnixValue/86400+"1/1/70"
then formatting as date...

but VFP has no way of converting the resulting serial number (38091.625)
to
a DateTime value like Excel....or does it?

Any help is appreciated, in a pinch so may cross post apologize in
advance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Unix DateTime to VFP DateTime

comp.databases.xbase.fox comp.databases.xbase.fox

Unix DateTime to VFP DateTime - 04-21-2004 , 04:33 PM

Re: Unix DateTime to VFP DateTime - 04-23-2004 , 02:54 PM