Views help - Date in Where clause

[Vlad Pronin]

Hi!
I have table with [EntryDate] field in it.
I have problem creating where clause with selection for last 30 days
starting from today's day.

Any help appreciated.

Thanks

 

[Anith Sen]

You can do :

WHERE dt BETWEEN DATEADD(d, -30, CURRENT_TIMESTAMP)
AND CURRENT_TIMESTAMP

 

[David Portas]

....
WHERE entrydate >= DATEADD(DAY,-29,CONVERT(CHAR(8),CURRENT_TIMESTAMP,112))

 

[dh]

GETDATE() and CURRENT_TIMESTAMP both return date+time, FYI. So subtracting
30 may only give you partial days, depending on when you run the query.

 

[Brian Burgess]

What if 'entrydate' could be either positive or negative number? Any way
of doing this easily in the WHERE clause?

Thanks in advance...

-BB

...
WHERE entrydate >= DATEADD(DAY,-29,CONVERT(CHAR(8),CURRENT_TIMESTAMP,112))

--
David Portas
------------
Please reply only to the newsgroup
--

Hi!
I have table with [EntryDate] field in it.
I have problem creating where clause with selection for last 30 days
starting from today's day.

Any help appreciated.

Thanks