[Solved] select yesterday date in where condition

by 


SELECT
* 
FROM yourTable
WHERE 
(FilteredPhoneCall.createdon >= dateadd(day,datediff(day,1,GETDATE()),0)
    AND FilteredPhoneCall.createdon < dateadd(day,datediff(day,0,GETDATE()),0)) 
OR
(FilteredPhoneCall.modifiedon >= dateadd(day,datediff(day,1,GETDATE()),0)
    AND FilteredPhoneCall.modifiedon < dateadd(day,datediff(day,0,GETDATE()),0))

solved select yesterday date in where condition