Try adding this to your code: MOVE &dateinit to $dateinit DATEDIFF(day, WO.REPORTDATE, $dateinit) >From WORKORDER WO Where WO.WONUM = '15485' Anthony B. Moore Front End Development BellSouth Cellular Corp. (770) 351-1382 email: Anthony_B_Moore@bscc.bls.com