12 Hour business day

This tip describes configuring your system for a 12 hour business day.

When a user faces any problem, help desk creates a ticket for him/her and put a time stamp on it. We want to track

how many business hours took to solve a problem. Our Business hours are 6:00 AM to 6:00 PM, from Monday to Friday. So if a ticket has been reported outside of this window then Adjusted Time should be next day i.e. Next business day at 6:00 AM.


@If(OpenDate = ""; 
@Return(""); @Success);
WeekDay := @Weekday(OpenDate);

DayAdjust := @If(
WeekDay = 6 & 
@Hour(OpenDate) >= 18   ;  
  3;
WeekDay = 7;              2;
WeekDay = 1;              1;
@Hour(OpenDate) >= 18;          
 1;                              0);

TimeAdjust := @If (@Hour
(OpenDate) < 6 | DayAdjust != 0;
 "06:00 AM"; "");

AdjDate := @Text(@Adjust
( @Date(OpenDate) ; 0; 0; 
DayAdjust; 0; 0; 0));

@If( DayAdjust = 0 & TimeAdjust = ""; 
OpenDate; @TextToTime(AdjDate 
+ " " + TimeAdjust))
This was first published in January 2003

Dig deeper on Lotus Notes Domino Formula Language

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.uk

Close