Local ldEndDate
ldEndDate =  "09/22/2004"

SQLEXEC(tConnection, 'SELECT Tally.ReworkNumber, Tally.Problem, ' + ;
'TallyDetail.Kanban, TallyDetail.PartNumber, Tally.PartName,' + ;
 'Tally.SupplierName ' + ;						
'FROM Tally, TallyDetail ' + ;
'WHERE Tally.ReworkNumber = TallyDetail.ReworkNumber ' + ;
'AND Tally.DateCreated = ' + TRANSFORM(m.ldEndDate) ,'cuWeekly')