
	Home > Domino Tips > Developer > Formula > Simulate R6 @Businessdays in R5

Domino Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

FORMULA

Simulate R6 @Businessdays in R5

Stephan Wissel
02.03.2003
Rating: -5.00- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

You had a look at R6 and the overhaul of the formula language. Nice updates. For calculation of working days @Businessdays replaces a lot of legacy script... However your client base is on R5. Don't worry you can have it in R5... Thanks to the power of lists.

Code

 R6:
tmpWeekEnd:= 1:7;
tmpHolidays := [01/01/2003] :
 [15/01/2003] : [16/02/2003] :
 [28/05/2003] : [04/07/2003];
@BusinessDays(FirstDay;
Lastday;tmpWeekEnd;tmpHolidays)

R5:
tmpWeekEnd:= 1:7;
tmpHolidays := [01/01/2003] : 
[15/01/2003] : [16/02/2003] : 
[28/05/2003] : [04/07/2003];
REM "Create a textlist that 
contains all days in the period";
tmpDatelist := @Text(@Explode
(@TextToTime(@Text(Firstday)+"
 - "+@Text(Lastday))));
REM "Replace the holidays out of the list";
tmpNoHolidays := @TextToTime
(@Trim(@Replace(tmpDatelist;
@Text(tmpHolidays);"")));
REM "Remove Weekends";
tmpWeekdays := @Text(@Weekday
(tmpNoHolidays));
tmpWorkdays := @Trim(@Replace
(tmpWeekdays;@Text(tmpWeekEnd);""));
@Elements(tmpWorkdays)

Rate this Tip
To rate tips, you must be a member of SearchDomino.com. Register now to start rating these tips. Log in if you are already a member.
Submit a Tip

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Formula
	View hidden fields on Lotus Notes/Domino forms
	Case-insensitive @Unique version combines fields on Lotus Notes forms
	Provide rich-text formatting via the Profile document and Formula
	Using Formula language code to sort Lotus Notes messages by subject
	How to create dynamic JavaScript in Notes Domino without formulas
	Formula language button manages Deny Access list searches
	Retrieve Lotus Notes names from a nested group using @DBLookup
	Create a computed Lotus Notes field to list Personal Address Book names
	Show multiple Lotus Notes document fields in a single view column
	How to send a document as a link in a Lotus Notes email

Lotus Notes 5

Mass-input form uses LotusScript to ease large-scale employee moves

Track and record Lotus Notes user logins to Domino Server

How to fix the size limitation on Lotus Notes summary text fields

How to correct Lotus Notes public key mismatches in four easy steps

Moving a remote user mail database to new Lotus Domino server

OpenNTF OpenLog

Calendar delegation problem with Lotus Notes client 6.5.5 upgrade

Advice sought re lack of Notes/Outlook interoperability

Availability of R6 update exam

After Notes upgrade, LotusScript mail function doesn't work

Lotus Notes Domino Formula Language

View hidden fields on Lotus Notes/Domino forms

Case-insensitive @Unique version combines fields on Lotus Notes forms

Do I use Formula or LotusScript to include a doclink to a Notes view?

Top 10 Lotus Notes/Domino coding and development tips of 2008

Provide rich-text formatting via the Profile document and Formula

Top 10 Formula language tips

Using Formula language code to sort Lotus Notes messages by subject

How to create dynamic JavaScript in Notes Domino without formulas

Stop response documents from showing in a Lotus Notes form

Formula language button manages Deny Access list searches

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Domino & Lotus Notes Security Solutions: Authentication, Antispam, Encryption and Antivirus

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 1999 - 2009, TechTarget \| Read our Privacy Policy