Re: Sql Date Question

Hi
Add('Select * from Table1');
Add('Where APPTDATE >= ' +
QuotedStr(FormatDateTime('mm"/"dd"/"yyyy', FromDate)));
Add(' AND APPTDATE <= ' +
QuotedStr(FormatDateTime('mm"/"dd"/"yyyy', ToDate)));
Add('Order by LeadNo');
The above sql stmt works find if the from & to dates are within the same
year but not if the years is different. The table will have many yeats on
it.
Something is amiss but I can't figure it out.

Why shouldn't it have more than one year in it?
What year are you looking for?
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.