3 Replies Latest reply on May 13, 2016 6:57 AM by beverly

    Converting executeSQL date data to native filemaker date format

    SunnyChu

      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