Calculated Date

[bluesky]

Hi -

I have a date field called: card_sent.

I'm giving people 7 business days from "card_sent" date before I make a
follow up telephone call to them. So, I need to pull all the records of
those whom I need to call, that is, those who were sent a card 7 or more days
ago.

Thanks
Any help is greately appreciated.

-bluesky

 

[Jerry Whittle]

In the criteria put:

< Date() -7

 

[Ken Snell \(MVP\)]

SELECT *
FROM TableName
WHERE card_sent <= DateAdd("d", -7, Date());

 

[bluesky]

Thanks Jerry! It worked...

Two more quick questions:

How can I actually show a new "call_date" field in my query?

AND

What if I wanted to run a query and have all my records come up with a
"call_date?" (that is 7 days from "card_sent")

Thanks a bunch!!

 

[bluesky]

Hi Ken,

Thanks for your reply. I'm getting some errors....this is what I wrote....

calldate is my new field, is this the correct place for it?

SELECT calldate
FROM Tracking Table
WHERE card_sent < = DateAdd("d", -7, Date( ) );


Thanks!

 

[bluesky]

OK, I got it to work, but what I really want to do is is make a new field
called "calltime" or something like that. And return ALL records, with their
call dates, which could be in the past or future...

thanks,

debbie

 

[Ken Snell \(MVP\)]

Perhaps this:

SELECT *, DateAdd("d", 7, [card_sent]) AS CallDate
FROM TableName;