Select date columns value which are older than 10 days from today?

Question

Select date columns value which are older than 10 days from today?

Viewing 9 posts - 31 through 38 (of 38 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 1

kaiitong (3/18/2008)
Did this topic ask for another of my perspective? No
Do I look like want your concern? NOPE
Did you come to answer my question? No
Why this topic's still active since the owner of the topic said "Please end it"? I don't know
This is enough for me. I'll unsubscribe to this topic.
But If It's not enough for you, ENJOY YOUR TIME
PS. If I missed out the rule that a student cannot ask a question, I'm sorry. But If there's not, please take rule description and stick it on the top. That'll be very thankful.:D

Heh... I thought you gave up on this topic a long time ago... might be some hope for you yet.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Based on the OP's last posting, he might not see the posting after his. I dropped him a PM trying to explain some of our opinions and the reasoning behind them. I don't know if he is open to the input, but can only hope. I tried to explain that we are more than willing to help, just that as a student we expect him to work harder for the answer rather than expect it to just be handed to him. We want students to come and ask questions, but when they leave it would be much more satisfying to us if they actually understand what they got, and can remember it when they go out into the real world of IT.

Well that is just the jist of what I said, so we'll see.

😎

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

If he cut us off, it's because he's already an "adult"... not sure I'd waste time on a PM... remember what I said...

most adults have already lost theirs so not worried about them

You can lead a horse to water... and you can make him drink... I just don't like taking a suction on the part of the horse that's necessary to make that work 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Well, there is always hope. I've learned a lot more through this site, and some of that is from you. I think I try harder on some things because I know you'll see it some time, and I don't want to get yelled at too much. Actually, your critisism is usually very contructive and helpful in learning concepts and how things should or can be done.

By the way, you seem to haunt this site a lot. 😉

😎

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 5

By the way, you seem to haunt this site a lot.

Heh... can't dance and it's too wet to plow 🙂

Thanks for the awesome compliment, Lynn... lot's of good folks on this forum deserve the same including present company.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 6

Jeff Moden (3/18/2008)
You can lead a horse to water... and you can make him drink... I just don't like taking a suction on the part of the horse that's necessary to make that work 😉

You know - visuals like that just are NOT kind to the psyche....sheesh:D

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 7

Heh... did I make ya blow coffee out your nose, Matt? 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 8

Jeff,

I did get a favorable reply to my PM. Not to go into details, but in my reply back I did point the OP to your article on how to ask for help telling him the it would help us help him. Also told him not give up on us and we would not give up on him. Also suggested that he post back what he learned, his solution. Warned him he might get some critisism, but that it would be (hopefully) constructive and help show other ways things could be done.

We'll have to wait and see.

😎

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 9

I got a PM as well and I'll close down this topic since we've slightly wandered away from the question. I did explain that I thought he/she hadn't done enough work and shown an effort, but I think we got slightly personal here.

I can appreciate the frustration, and I have bad days like everyone else, but please try not to pick on someone too much. It might be ignorance as easily as laziness.