AnsweredAssumed Answered

Converting executeSQL date data to native filemaker date format

Question asked by SunnyChu on May 29, 2015
Latest reply on May 13, 2016 by beverly

Title

Converting executeSQL date data to native filemaker date format

Post

Hi,

I recently tried to use executeSQL to get a date data from one of my filemaker table (that field is a timestamp btw). I realize the date format is different to filemaker's normal one, I tried a few different ways to change it but it doesn't seems to work. Are there any existing function in filemaker that can do this for me?

Thanks in advance

Sunny

Outcomes