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')