[RESOLVED] How to query data of column Current Date and all Previous Date in sql server 2008

[BONITO]

hi all,

Please help me with my project I am newbie.

I want to query all the data that has the current date and previous date only.

here is my table structure:

Create table PM_Schedule(
Feeder_Name nvarchar(50)primary key not null,
Start_Working_Date Date not null,
Working_Time_Start varchar(10) not null,
Working_Time_Stop varchar(10) not null,
Status nvarchar(10) not null,
Description nvarchar(50),
DateClose Date
)

below is the actual data in my table , as you noticed in column Start_Working_Date I have different date. the highlighted date are the date i want to query only in my other data grid view. they are the current date and the previous date.


how can i do it ?



Note: i don't want to query the date that is greater than the current date.
thank you in advanced.