Converting Date in orders.dbf

[duvys]

How can I understand / convert the date in orders.dbf?

I downloaded orders.dbf but the dates are in a 10 digit format which I can seem to understand.

[Bruce - PhosphorMedia]

Here's the forumla for excel:

=DATEVALUE("1/1/1970") + (B1)/(24*3600) + 9.5/24


the Merchant data formula in universal time is in cell B1.

[Vic - WolfPaw Computers]

They are in Unix T-time. Its a standard date format.

Here is a link to a page with a converter you can setup as a formula in Excel to convert it.

http://exceltips.vitalnews.com/Pages/T0096_Converting_UNIX_DateTime_Stamps.html

[ILoveHostasaurus]

That's the number of seconds since 1970, but only unix people would know that. :-) Here's a nice web convertor:

http://www.onlineconversion.com/unix_time.htm

[duvys]

Thank You! that worked.