I am extracting data from a mysql database and putting the data into a configured table on Zohoreports.  All was working fine untill the company upgraded their database and now instead of a nice easy to read date format,  I see an EPOCH.  

What do I need to do to make my report realise that the epoch is a date and can translate it?

I tried just making it a date field but  no joy :(

Totally lost now.  Any help would be appreciated