how to get the yest'day date in c#.net

Hi ,
     U can do this by writing the stored procedure like that.
declare @PreviousDate varchar(30)
declare @CurrentDate varchar(30)
set @PreviousDate = (select convert (varchar(30),getdate()-1,101)+' 18:00:00.000'  )
set @CurrentDate = (select convert (varchar(30),getdate(),101)+' 18:00:00.000' )

select * from TableName where CreatedDate between @PreviousDate and @CurrentDate

hi, you can use the DateTime.Now().AddDays(-1) params to create a new DateTime like

DateTime minus1day = DateTime.Now().AddDays(-1);
minus1day = new DateTime(minus1day.Year, minus1day.Month, minus1day.Day, 18, 0, 0);

Johnny.