Exclude weekends

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

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
 
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")
Click to expand...

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")))
Click to expand...


--

Cheryl Fischer, MVP Microsoft Access



Dan said:
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
.
Click to expand...
Click to expand...
 
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 said:
I also try to implement this function, but not works? I put next statement
Click to expand...
in my query: TotalDays: Work_Days([begdate]-[enddate]) What do I wrong?
 
Back
Top