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 - 2012-03-15 - 08:30:00 - Call Arthur Murray to finalize data 1172 -…

FileMaker SQL: Simplify and Stay on Screen FileMaker 12 lets us run SQL queries against our own FileMaker tables. This has been possible with plugins for a while and a number of serious devs like Mike Lee, Greg Lane, and Kevin Frank have been talking about what a great technique this is. I completely agree and think the new ExecuteSQL calc function is the killer feature of FileMaker…

We’re thrilled to announce our new Free Calendar Template for FileMaker 12. We’ve rewritten the free calendar to take advantage of some of the new things in FileMaker 12, including the new look and feel, but perhaps most importantly, the new ExecuteSQL function. This makes the new calendar simpler, less dependent on context, and easier to integrate. Checkout this short introduction demonstrating how this new SQL stuff makes…