Identifying week range by todays date

werosen1 · Joined: 16 Apr 2006 Posts: 2

I'm trying to write an SQL query that identifies today's date, and then provides the date range for that date's week, so I can return all my database

records that fall in that week's date range and display them in my ASP page.

Is there a way to do this?

Regards

paul · Joined: 11 Oct 2004 Posts: 128

The SQL statement will be different for different database servers. What database do you use?
_________________
World Countries | Survival Skills

rose · Joined: 21 Feb 2006 Posts: 29

And are you using asp or asp.net?

administrator · Site Admin Joined: 01 Oct 2004 Posts: 183

He can do this directly from SQL, so the technology (ASP or ASP.NET) doesn't really matter.
_________________
Peter
ASP & ASP.NET Articles and Tutorials

James · Joined: 20 Feb 2006 Posts: 24

Can someone post how it would be done using MS SQL?
Its likely he is using that database I would say Smile