>WITH ThisForm > .dFrom=.txtStartdate.Value && Used in report form. > .dThru=.txtEndDate.Value && Used in report form. > lcStartDate=DTOC(.txtStartdate.Value) > lcStartDate=SUBSTR(lcStartDate,7,4) + ; > LEFT(lcStartDate,2) + ; > SUBSTR(lcStartDate,4,2) > lcEndDate=DTOC(.txtEndDate.Value) > lcEndDate=SUBSTR(lcEndDate,7,4) + ; > LEFT(lcEndDate,2) + ; > SUBSTR(lcEndDate,4,2) > SELECT ; > si.cust, ; > cs.customer, ; > si.StandsIn, ; > si.DateIn ; > FROM ; > STANDSIN si, ; > Customer cs ; > WHERE ; > BETWEEN(datein, .dFrom, .dThru) AND ; > si.cust = cs.custno ; > GROUP BY ; > si.Cust, ; > cs.customer, ; > si.standsin, ; > si.DateIn ; > ORDER BY cs.Customer ; > INTO TABLE C:\si_rpt >If the .datein field is a datetime, that'd explain why you aren'g getting anything for that date. It would be a few minutes and/or hours after today at 00:00, and your .dThru internally converts to {^2008-02-08 00:00:00}. So your last record would be AFTER your .dThru and would be excluded.