Statement return error

[Elena]

Hi!
I want to select just 1 day older rows from table.
I run next statement:

select*from report
where Date = ltrim (DATEPART (dd,GETDATE())>1)+'/'+
ltrim (DATEPART(mm,GETDATE()))+'/'+ltrim (DATEPART(yyyy, GETDATE()))

the datetime in the column Date is: dd/mm/yyyy

and here is error message:

Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '>'.

I tried everything , but can't get rid of this error message.
Please help!

[Steve]

I believe one of these is the solution you are looking for:

If the Date column is a datetime datatype this would be an easier solution:

select * from report
where DATEDIFF(dd, Date, GETDATE()) = 1

Else use this modifcation to your current statement:

select * from report
where Date = LTRIM(DATEPART(dd, GETDATE()) + 1) + '/' +
LTRIM(DATEPART(mm, GETDATE()))+ '/' + LTRIM(DATEPART(yyyy, GETDATE()))

Steve

------------
Elena at 1/12/00 11:31:34 AM

Hi!
I want to select just 1 day older rows from table.
I run next statement:

select*from report
where Date = ltrim (DATEPART (dd,GETDATE())>1)+'/'+
ltrim (DATEPART(mm,GETDATE()))+'/'+ltrim (DATEPART(yyyy, GETDATE()))

the datetime in the column Date is: dd/mm/yyyy

and here is error message:

Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '>'.

I tried everything , but can't get rid of this error message.
Please help!