how to date()+20weekdays?

C

Cynthia

I need to update the values in a field (datatype is date) by adding 20 (or
some other figure) weekdays to each of the value. How could I do that? (the
dates in the field could be any day of the week. If I simply +20 to them, the
system will include weekend...)

Thanks a lot!
 
B

Baz

Posting the exact same question only 18 minutes after you previously posted
it is a pretty sure way of annoying people and hence getting no help.

If you want the best chance of getting fast answers then post at a time when
most or all of the USA is awake and at work.
 
C

Cynthia

If you knew this website well enough, you may realize that the post was
sometimes delayed or not shown properly. I was also annoyed for having to
type it twice as the first one didn't show up until half hour later.

So, do not judge others especially when you were not in their shoes.

I appreciate your reply and help though. And wish you a nice day!
 
B

BruceM

If you suspect a question has not posted properly, it is probably best when
posting again to write something like "I thought I had posted this question
a half hour ago, but I don't see it, so maybe it didn't go through." Quite
a few people have fired off the same question at short intervals, so without
the explanation about the reason for posting again it could look as if you
are being impatient.
BTW, the "w" interval in DateAdd does seem to be rather worthless, doesn't
it?
 
Top