How is date/time translated?

[Reeve of shinra]

I did a simple query to pull a list of users but things like the Join Date are stored in some format I dont recognize.

I dont need the vb code to translate it but I do need to know how vb does it cause its an excel sheet.

[Reeve of shinra]

Nevermind, found out in another thread that its based on unix time stamp and some googling found me the formula:

=A1/86400+"1/1/70" where A1 is the field with the unix date

[Dean C]

Please note vBulletin questions and how do I's such as this should be posted in General vBulletin Questions. I've moved it there nevertheless for future reference for others