Exclude weekends

Hi:

Can anybody tell me how to exclude the weekends from the
rezult of: now()+5 - to calculate just the working days!!?

Thank you,

Dan

Dan,

There are some really great functions for doing workday math at:

http://www.mvps.org/access/datetime/date0012.htm

The first one listed in the code at that link might be just what you're
looking for.

--

Cheryl Fischer, MVP Microsoft Access



"Dan" wrote in message
...
Hi:

Can anybody tell me how to exclude the weekends from the
rezult of: now()+5 - to calculate just the working days!!?

Thank you,

Dan

Thank you, Cheryl! I will try and run my query....

Dan
-----Original Message-----
Dan,

There are some really great functions for doing workday
math at:

http://www.mvps.org/access/datetime/date0012.htm

The first one listed in the code at that link might be
just what you're
looking for.

--

Cheryl Fischer, MVP Microsoft Access



"Dan" wrote in
message
...
Hi:

Can anybody tell me how to exclude the weekends from the
rezult of: now()+5 - to calculate just the working
days!!?

Thank you,

Dan


.

Hi Cheryl:

I do not konw how to correlate the first function with
this criteria in my query/report:

DT: IIf((IIf([reason]="t1",[order_dat]+2,IIf([reason]
="t2L",[order_dat]+30)))))))=Date()+5,"Your Transcript is
due in 5 days")

I would appreciate your help.

Thanks,

Dan
-----Original Message-----
Thank you, Cheryl! I will try and run my query....

Dan
-----Original Message-----
Dan,

There are some really great functions for doing workday
math at:

http://www.mvps.org/access/datetime/date0012.htm

The first one listed in the code at that link might be
just what you're
looking for.

--

Cheryl Fischer, MVP Microsoft Access



"Dan" wrote in
message
.. .
Hi:

Can anybody tell me how to exclude the weekends from
the
rezult of: now()+5 - to calculate just the working
days!!?

Thank you,

Dan


.

.

I'm working on it for you ...

However, the calculated field that you provided is not acceptable to the
query designer when I try to test it. Does it run in your query? Would
you mind posting the logic that you want, particularly the part between the
**:

DT: IIf((IIf([reason]="t1",[order_dat]+2,IIf([reason]
="t2L", *[order_dat]+30)))))))=Date()+5*,"Your Transcript is
due in 5 days")

Seems to me that it should be something like:

DT: IIf([reason]="t1",[order_dat]+2,
IIf([reason] = "t2L", some date calculation,
IIf([order_dat]+30=Date()+5,"Your Transcript is
due in 5 days")))


--

Cheryl Fischer, MVP Microsoft Access



"Dan" wrote in message
...
Hi Cheryl:

I do not konw how to correlate the first function with
this criteria in my query/report:

DT: IIf((IIf([reason]="t1",[order_dat]+2,IIf([reason]
="t2L",[order_dat]+30)))))))=Date()+5,"Your Transcript is
due in 5 days")

I would appreciate your help.

Thanks,

Dan
-----Original Message-----
Thank you, Cheryl! I will try and run my query....

Dan
-----Original Message-----
Dan,

There are some really great functions for doing workday
math at:

http://www.mvps.org/access/datetime/date0012.htm

The first one listed in the code at that link might be
just what you're
looking for.

--

Cheryl Fischer, MVP Microsoft Access



"Dan" wrote in
message
.. .
Hi:

Can anybody tell me how to exclude the weekends from
the
rezult of: now()+5 - to calculate just the working
days!!?

Thank you,

Dan


.

.

I also try to implement this function, but not works? I put next statement in my query: TotalDays: Work_Days([begdate]-[enddate]) What do I wrong?

I'm not sure where you got your Work_Days() function but I expect you need
to replace your "-" with a comma.
TotalDays: Work_Days([begdate], [enddate])
--
Duane Hookom
MS Access MVP


"Herman" wrote in message
...
I also try to implement this function, but not works? I put next statement
in my query: TotalDays: Work_Days([begdate]-[enddate]) What do I wrong?