UBB.Dev
I've just exported an excel file from phpmyadmin, containing the U_registered table. Now the dates are like "1039541295" and I would like to see them as 10/12/02.
Does anyone know how to convert this sql date in Excel ?

Thanks in advance
=(A1/86400)+25569

Where A1 contains the epoch time that needs to be translated. Then format those cells (the ones with the formulas) to display as Date and you're good to go.
Thanks a lot DLWebmaestro!
Another challenge :
https://www.ubbdev.com/forum/showflat.php/Cat/0/Number/128954/
© UBB.Developers