OK, so Ive exported the members table from the mysql databse.
What is the format of the lastlogin datefield, or to be more precise, howcan I convert 1397656420 into d//m/y in Excel?
It is a unix timestamp
Convert via SQL
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_from-unixtime
Thanks - time to strap on my SQL cojones!