var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: date help
can someone help me
how can i pull all users from registration where date is
1. between yesterday (always yesterday) and one week before. (by date not by time)
2. the week before week 1
3. week before week 2
4. week before week 3
FROM dbo.users u
WHERE u.registrationDate BETWEEN DATEADD(ww, -1, GETDATE()) AND DATEADD(dd, -1, GETDATE())
I'm guessing that you can figure out the rest on your own. If you can't please post what you've done so far so we can provide any further assistance.
Get some flowers. Think of a few nice things to say to her, and take her to a nice place (McDonald's won't cut it here)....Oh, sorry. i was only going off the thread title. Nevermind.
Originally Posted by MCrowley