Submit a Code Fragment... Submit a Code Fragment...
Previous Next Expand Collapse Search
CategoryLink to viewNameLink to viewDescriptionSourceLink to viewDateLink to view
ActiveX/OCX/OLEAnonymous02/03/2004
ActiveX/OCX/OLEAnonymous09/04/2007
C/C++File Input/OutputAnonymous05/26/2000
C/C++User Interface (Web)killDominoAnonymous12/31/2001
C/C++Anonymous02/03/2004
C/C++Anonymous09/04/2007
FormulaDate/Time HandlingWeekdayComputes number of weekdays between two dates.Rlatulippe@romac.com02/13/1999
FormulaDate/Time HandlingDay of the YearComputes the day number of the yearRlatulippe@romac.com02/13/1999
FormulaDate/Time HandlingWeekending dateWeekending date for a specific dateRlatulippe@romac.com02/13/1999
FormulaDate/Time HandlingMonth number to nameConverts 1 to January, 2 to February, etc.Jamie Magee10/31/1999
FormulaDate/Time HandlingConverting seconds to d:h:m:srobert.j.wragg@britishairways.com02/28/2000
FormulaDate/Time HandlingAdjust a Date Into the FutureAdjusts a date field ahead by one year. This type of formula is ideal when you want to compute a date into the future based on a date entered into a particular field. For example, the formula listed below is used to set a warranty expiration date (WarrantyExpires) one year from the date of purchase (DatePurchased).Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingAppend "Yesterday", "Today", or "Tomorrow" to DateThis formula makes it easier in your views to see that this date is yesterday, today, or tomorrow's date. For example, a view would appear as follows: 3-09-94 First entry Second entry 3-10-94 (Yesterday) First entry Second entry 3-11-94 (Today) First entry Second Entry 3-12-94 (Tomorrow) First entry Second entry Third entry 3-13-94 First entry Second entry In a Column Formula of a View:Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingCalculate Time AssignedSets time field when assigned to help desk person.Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingGet the Next MonthThe following routine will determine what the next month is following the month curently being displayed. If the next month is January, then the routine will increment the year by one.Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingDay of Year FormulaDay of Year FormulaRlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingPrecompute List of Monthly DatesThis formula generates a list of dates.Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingView Selection for Current Month DocumentsThis View Selection Formula returns only documents created during the current calendar month.Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingCalculate the week number in a year of a given date.Calculates the week number in a year of a given date.Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingConvert @Today to Month Day, YearRlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingGet the Previous MonthThe following routine will determine what the previous month is following the month curently being displayed. If the previous month is January, then the routine will subtact one to lower the year.Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingConvert Month Name to Month NumberThe following code will convert a Month long name to the corresponding Month number.Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingCalculate # days between two datesRlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingClient Contact Time PeriodWhen determining when a client needs to be contacted after a specified period of time, follow this tip:Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingMonth Column CalculationsMonth Column CalculationsRlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingCalculate the number of weekdays between two date fields?The following formula counts the number of weekdays (but not weekend days):Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingCalculate The Number of Days Between Two DatesUse this formula to calculate the number of days between two dates.Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingPrecompute List of Weekly DatesSets up keyword field with list of dates, all on the same day. Formula below set to calculate Fridays and return the next five Fridays. Formula can be altered easily to yield more dates, past dates, some past/some future dates, etc.Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingHours Between Two TimesDetermine the number of hours between two times.Rlatulippe@romac.com04/19/2000
FormulaDate/Time HandlingCalculating Business Days Between Two DatesIt is elementary for a Notes programmer to calculate the number of calendar days between two dates (It is even quite easy to calculate the non-weekend days between two dates. However, it is much tougher to calculate the number of business days given a list of holidays. This requires some form of recursion or looping to check 1) if a holiday falls anywhere within the range, or 2) if any of the dates in the range is on a list of holidays. The presumption is that you don't know exactly how many calculations you need to make, hence the need for recursion or looping. The following example demonstrates a recursive mechanism to do this calculation. It uses a button and three macros. Two dates are supplied. A button is avialable to calculate and set the value for a third field containing the number of business days. A text list containing the holidays must also be available, either in a variable or through a lookup.Rlatulippe@romac.com04/19/2000