How is date/time translated?
 

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.

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

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 :)