Convert to Date from number

Discussion created by dgurusamy on Jul 29, 2015
Latest reply on Jul 30, 2015 by dgurusamy

I'm retrieving records form the MySql database to my FileMaker. Its working fine.


but the date field is not showing proper date format in FileMaker, which means Its shows numbers only (1438176871) Instead of the date (28/07/2015)


I think I need a function to covert this number to date - I have tried with FileMaker predefined functions - But no use up to my knowledge.


Can someone please help to fix this issue and get the date format from this number ? anybody has faced this issue before.


Many Thanks