WHERE T0.DocDate>=CONVERT(CHAR(10), GETDATE()-1, 112) AND T0.DocDate<CONVERT(CHAR(10), GETDATE(), 112)