Simple query with GetDate 1

[JohnShell]

Hi,

Have table with one column "dateRequested" which is the current date and another column "reqDecision" which is boolean (yes/no or null if not entered). I want to query those columns and get the fields that are the current date minus one day and "reqDecision" equals "null".
How is that done?

Thanks - John

 

[markros]

declare @Yesterday datetime, @Today datetime
select @Yesterday = dateadd(day,datediff(DAY,'20100102',GETDATE()),'20100101'),
@Today = dateadd(day,datediff(DAY,'20100101',GETDATE()),'20100101')

select * from Table where DateRequested >=@Yesterday and
DateRequested < @Today and reqDecision IS NULL

PluralSight Learning Library

 

[JohnShell]

Markros,

Many thanks. I will try this tomorrow.

John