developerWorks

AIX and UNIX
Information Mgmt
Lotus
	New to Lotus
	Products
	How to buy
	Downloads
	Live demos
	Technical library
	Training
	Support
	Forums & community
	Events
Rational
Tivoli
WebSphere

Java™ technology
Linux
Open source
SOA and Web services
Web development
XML

My developerWorks
About dW
Submit content
Feedback

developerWorks > Lotus > Forums & community > Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum

@Adjust taking into account weekend days

@Adjust taking into account weekend days
Posted by KE P on 15.Oct.08 at 10:01 AM using a Web browser
Category: Domino Designer

Release: 6.0.5

Platform: Windows XP

We have the below formula in a view column to calculate closure target date dependent on case type, it is working fine but needs however to calculate the target date to the next working day if ClosureDate falls on a weekend day... I'm having problems amending the formula to include the additional calculation as I don't have much experience of formula language.

Any suggestions would be greatly appreciated..

ClosureDate:= @If(ClosureSLA="" &
(CaseType= "Urgent Request!" |
CaseType = "Finance team" |
CaseType = "Customer request"
);
@Adjust(@Date(AcceptTime);0;0;1;0;0;0);
(CaseType= "Travel" |
CaseType = "Internal Request"
);
@Adjust(@Date(AcceptTime);0;0;3;0;0;0);
(CaseType= "DIT" |
CaseType = "Last Stage Calling"
);
@Adjust(@Date(AcceptTime);0;0;5;0;0;0);ClosureSLA);

Return to top

@Adjust taking into account weekend... (KE P 15.Oct.08)

. . RE: @Adjust taking into account wee... (Eva Valenta 16.Oct.08)

. . Seearch this forum for businessdays... (Carl Tyler 15.Oct.08)

. . . . RE: Seearch this forum for business... (Thomas H. Snelh... 15.Oct.08)

Document options

Print this page

Search this forum

Forum views and search

	Date (threaded)
	Date (flat)
	With excerpt
	Author
	Category
	Platform
	Release
	Advanced search

	Sign in
	Forgot your password?
	Forgot your user name?
	Create new registration

RSS feeds

	All forum posts RSS
	All main topics RSS
	More Lotus RSS feeds

Resources

	Forum use and etiquette
	Native Notes Access
	Web site Feedback

Lotus Support

	IBM Support Portal - Lotus software
	Lotus Support documents
	Lotus support by product
	Lotus support downloads
	Lotus support RSS feeds

Wikis

	IBM Composite Applications
	IBM Mashup Center
	IBM Connections
	IBM Docs
	IBM Forms
	IBM Mobile Connect
	IBM Sametime
	IBM SmartCloud for Social Business
	IBM Web Experience Factory
	Lotus Domino
	Lotus Domino Designer
	Lotus Expeditor
	Lotus Foundations
	Lotus iNotes
	Lotus Instructor Community Courseware
	Lotus Notes
	Lotus Notes & Domino Application Development
	Lotus Notes Traveler
	Lotus Protector
	Lotus Quickr
	Lotus Symphony
	IBM Web Content Manager
	WebSphere Portal

Lotus Forums

	Notes/Domino 9.0
	Notes/Domino 8.5 + Traveler
	Notes/Domino XPages development forum
	Notes/Domino 8
	Notes/Domino 6 and 7
	Notes/Domino 4 and 5
	IBM Connections
	IBM Forms
	IBM Mobile Connect
	IBM Sametime
	IBM SmartCloud Notes
	IBM SmartCloud Meetings
	IBM Web Content Manager
	Lotus Domino Document Manager
	Lotus e-learning
	Lotus Enterprise Integration
	Lotus Expeditor
	Lotus Protector
	Lotus Quickr
	Lotus SmartSuite
	Lotus Symphony
	Lotus Symphony Developer Toolkit Support
	Lotus Workflow