Try using this,
FROM UseMixtures u
WHERE u.DateUsed> ? " ;
"" ; "" ;
This should work.
The parameter's value should not be expressed in SQL's date syntax, but in FileMaker's date syntax. Haven't tried literal text so it might work. If not, try:
"" ; DateField )
"" ; Date ( 9 ; 30 ; 2013 )
"" ; getasdate ( "9/20/2013" )
Thanks, Saigopal & PhilModJunk.
Both answers worked; perhaps PhilModJunk's works a bit better because it will always be correct no matter what the system's preferred date format is.
I hadn't realized that the parameters needed to be in FileMaker's syntax. That should be the last piece of the puzzle, so that I can use the more complicated filter that gives me the exact answer (I pared this problem down to the bare minimum so it would be easier to understand).
The first two examples are independent of system date settings, but I believe that GetAsDate is not.
I got an email from Michael L. today (see following) which was a comment on this (but not posted here?); I'll answer it here:
Found this post as I am trying to do the exact same thing. However, I keep getting a question mark. Am I missing something here?
WHERE date > ? "; "" ; "" ;
Date ( 12 ; 31 ; 2013 )
Michael, your context is OK, but date is one of those SQL restricted words (check out https://drupal.org/node/141051). So change
date to \"date\" and it should work fine.
Thanks, William. I realized "date" was a reserved word after I posted my question, and so deleted it. Sorry you still got the email. However, my solution was to change the field name. I didn't realize I could just add the \" on either side. Thanks for the tip!