I am having trouble getting BETWEEN to work.
Here is an example of the way I am trying it...SalesReportPL is a FileMaker table
~SD = Date ( 1 ; 1 ; Year ( Get ( CurrentDate ))) ;
~ED =Date ( Month ( Get ( CurrentDate )) + 1 ; 0 ; Year ( Get ( CurrentDate )))
WHERE SaleDate BETWEEN ? and ? " ; "" ; "" ; ~SD ; ~ED ))
I get a zero even though there are sale dates between those dates. I've tried hard coding the dates.