>I'm sorry that's not true. It can't pick up any of the dates I put in for member dates. IF its in between those dates it doesn't matter. If its not it doesn't matter nothing prints.
>
Tyler,

First, is this a native VFP SQL call? I assume that it is. If so, something like the following should work:

lnyear = YEAR(DATE())
ldstart = DATE(lnyear - 1, 4, 1)
ldstop = DATE(lnyear, 3, 31)
SELECT *;
  FROM MyTable;
  WHERE BETWEEN(mytable.datefield, ldstart, ldstop);
  INTO CURSOR Whatever

A couple of things to note. First, the above uses syntax that wasn't available prior to VFP 6.0. Second, the DATE() function returns the appropriate date format. Third, it should be faster that using macro substitution.