How to retrieve the past date values

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to retrieve the past date values

Author

Topic

kun527
Starting Member

1 Post

Posted - 2008-11-19 : 17:45:48

Hi,

I am new to this group.
I need some help from this group for a question.

How I need to write a expression to retrieve the past 10 date values in SSRS. i had a column called due date in which it has some date values.From this i need to retrieve the last 10 date values comparing with the system date.
Can you please let me know if anyone knows.

Thnx,
kun

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2008-11-19 : 18:15:53

How do you want to compare the dates to the system date?

Maybe ths will help get you started:

SELECT TOP 10 date
FROM MyTable
ORDER BY date DESC

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-20 : 00:43:18

where do you want to generate dates? in code behind or inside designer? something like below should work
=DateAdd("d",-1 * RowNumber(Nothing),Now())

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources