Converting executeSQL date data to native filemaker date format
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