The problem. SQL, including the new ExecuteSQL calc function in FileMaker 12, returns dates in this format: YYYY-MM-DD. This can be a bit of a pain if you have a string of text like this and just want to transform the date part: 1170 - 2012-03-09 - - Keep: Beta Presentation @ BRN Co 1171 […]