Dates From Last Week?

[junkjones]

I have a query where I need to find out information from the past week. It looks something like this:

lastmonday = "08-04-2003"
lastsunday = "08-10-2003"

SQL = "select * from table where (dateran BETWEEN lastmonday and lastsunday)"

This part works, but I'm having troubles figuring out how to get a value for 'lastmonday' and 'lastsunday'. It's easy to do a date subtract and take off a certain amount of days, but the amount to subtract would be different depending on what day it is. Any suggestions?

 

[mwolf00]

today = date()

lastMonday = dateAdd("d",-1 * (datePart("w",today)-2),today)
lastSunday = lastMonday + 6


Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[Tarwn]

Nice

 

[Tarwn]

Oh, btw, you may want to use Now instead of today, think today is not valid in VBScript.

Here's my monday of last week script:

lastWkMon = DateAdd("d",-1 * (WeekDay(Now) + 5),Now)

Pretty similar except I had a differant interpretation of which week we wanted monday from.

[sub]01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111[/sub]

http://www.tiernok.com/

The never-completed website

 

[mwolf00]

tarwyn - didn't use today, I used date() which is the same as now() without time of day info....

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[Tarwn]

Sorry, tired from overworking myself this week
I saw that tyhe first time around but missed it the second time...

 

[clarkin]

and if you wanted to find the dates directly in sql server (say in a stored procedure) I did basically the same thing in this thread:
thread183-619930

I'm a bit leery of VBscript & dates.. very easy to be thrown off by regional settings on your (ASP) server

Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].