I am trying to retrieve sales data for the last 90 days but I'm running into formatting issues. SQL's format is YYYY-MM-DD while Get(CurrentDate) is MM-DD-YYYY. My SQL statement is as follows:
ExecuteSQL("SELECT SUM(subTotal) FROM Orders WHERE CustomerID = ? AND OrderDate > ?"; ""; ""; Customers::CustomerID; Get(CurrentDate) - 90)
but because the formatting are different... it's not working. What is the simplest correct way that I should be executing this SQL statement?
Filemaker Pro 13 Advanced
Thanks In Advance!