Submit a Code Fragment... Submit a Code Fragment...
Previous Next Expand Collapse Search
NameLink to viewDescriptionTypeLink to viewSourceLink to viewDateLink to view
68
Hide details for Date/Time HandlingDate/Time Handling
day differenceto find difference between two dates and find the day differenceLotusScriptRajiv Menon02/04/2001
Day of the YearComputes the day number of the yearFormulaRlatulippe@romac.com02/13/1999
lotus.notes.DateTime class2. This agent checks the result of getLocalTime against null to determine that the format of a DateTime value is invalid.JavaRlatulippe@romac.com04/19/2000
Converting seconds to d:h:m:sFormularobert.j.wragg@britishairways.com02/28/2000
Adjust 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).FormulaRlatulippe@romac.com04/19/2000
lotus.notes.DateTime class3. This script creates a new lotus.notes.DateTime object that represents today's date and then prints it in local time. The time component of the lotus.notes.DateTime object is not set.JavaRlatulippe@romac.com04/19/2000
AdjustSecond methodThis agent decrements the time by 10 seconds.JavaRlatulippe@romac.com04/19/2000
Append "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:FormulaRlatulippe@romac.com04/19/2000
Fetching Docs within a Date Range DynamicallyThere exists a set of documents in a databse. Inorder to retrieve the documents that exists within a given Date Range,the following code will be helpful.(if there is any simple code than this please inform the same) LotusScriptrkdravid@yahoo.com10/25/2000
Número de días, meses y años entre 2 fechasAqui veremos la cuantos días, meses y años hay entre 2 fechasFormulaAnonymous08/17/2000
ConvertToZone method and ZoneTime propertyThis agent converts the current time to zone 15 time.JavaRlatulippe@romac.com04/19/2000
Increment Elapsed Business Days without Company HolidaysThis agent increment elapsed business days without company holidays counted in. The formulae is simple and you can plug n play right away. Just remember you need a fields such RecvDate, HolidayCounter and Elapsed Days in the main form. And if your company does have db which has a listed holidays values in a document the below agent is good to go right away. Also, you can create a field the same document which will store company holidays dates and then you match with this dates field. Have Fun!!!!!Formulajsaiden@yahoo.com07/12/2000
AdjustHour methodThis agent decrements the time by 10 hours..JavaRlatulippe@romac.com04/19/2000
Calculate Time AssignedSets time field when assigned to help desk person.FormulaRlatulippe@romac.com04/19/2000
JavaScript pop-up calendarAllows user to select a date from a calendar, change months, years.JavaScriptesuez@mail.utexas.edu, jake.ochs@binarytree.com09/15/2000
How to Set Time Zone for a Date with the NotesDateTime Class in Notes R4Append the time zone after the time.LotusScriptRlatulippe@romac.com04/19/2000
AdjustYear methodThis agent decrements the date by 10 years.JavaRlatulippe@romac.com04/19/2000
Get 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.FormulaRlatulippe@romac.com04/19/2000
cuqxuabkqpnsl <a href="http://ahhhyieehvbo.com/">ahhhyieehvbo</a>, [url=http://laubhwvnapug.com/]laubhwvnapug[/url], [link=http://pvgtilmrbzat.com/]pvgtilmrbzat[/link], http://wjapxtymshuq.com/Formula,HTML,JavaScript,ActiveX/OCX/OLEAnonymous03/04/2015
lotus.notes.DateTime class4. This script creates two new lotus.notes.DateTime objects. The first represents January 15, 1900; the second represents January 15, 2000.JavaRlatulippe@romac.com04/19/2000
How to compare date/time fields using Lotuscript.This example will compare two date fields in document:LotusScriptRlatulippe@romac.com04/19/2000
Day of Year FormulaDay of Year FormulaFormulaRlatulippe@romac.com04/19/2000
Precompute List of Monthly DatesThis formula generates a list of dates.FormulaRlatulippe@romac.com04/19/2000
View Selection for Current Month DocumentsThis View Selection Formula returns only documents created during the current calendar month.FormulaRlatulippe@romac.com04/19/2000
Format date dd th mmm , yyyyThis code segment will format the current date in to "DD th MMMM , YYYY"
format. EX "31 st may , 2001"		Formulaudarap@www.com09/18/2001
TimeZone propertyThis agent prints the time zone in the creationDateSaved item of each document in the current database.JavaRlatulippe@romac.com04/19/2000
Calculate the week number in a year of a given date.Calculates the week number in a year of a given date.FormulaRlatulippe@romac.com04/19/2000
dates comparisonsJust a tip to compare 2 dates in lotusScriptLotusScriptFrancois09/21/2001
LocalTime property1. This agent prints the creation date and time of the current database in local time.JavaRlatulippe@romac.com04/19/2000
Calendar Set-UpThe code determines the date of the first Monday in any given calendar year. @Adjust can be used to determine the dates on which subsequent weeks begin and end. Use it to create a form that serves as a schedule or scheduler. (FIELD FR_2 := @Adjust(FR_1;0;0;7;0;0;0);
FR_2)		Formula<Wellford Dowdy> FourDowdys@cs.com01/15/2001
Next PaydayCalculates the next payday based on bi weekly pay on ThursdaysFormulapatcote1@airmail.net03/09/2004
Pop-up CalendarPresents a calendar of the current month when clickedFormulaRlatulippe@romac.com02/13/1999
Working with Notes time2. This agent determines the earliest and latest creation dates for all the documents in the current database, and creates a DateRange object using these dates.JavaRlatulippe@romac.com04/19/2000
Número de días, meses y años entre 2 fechasAqui veremos la cuantos días, meses y años hay entre 2 fechasFormulaAnonymous08/17/2000
Convert @Today to Month Day, YearFormulaRlatulippe@romac.com04/19/2000
Get 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.FormulaRlatulippe@romac.com04/19/2000
Weekending dateWeekending date for a specific dateFormulaRlatulippe@romac.com02/13/1999
Convert Month Name to Month NumberThe following code will convert a Month long name to the corresponding Month number.FormulaRlatulippe@romac.com04/19/2000
lotus.notes.DateTime class1. This agent creates a new lotus.notes.DateTime object and prints it in local time and GMT.JavaRlatulippe@romac.com04/19/2000
Calculate # days between two datesFormulaRlatulippe@romac.com04/19/2000
lotus.notes.DateRange class1. This example sets the StartDateTime and EndDateTime properties of a lotus.notes.DateRange object through the createDateRange parameters, then displays the value of the Text property.JavaRlatulippe@romac.com04/19/2000
LocalTime property2. This agent sets the local date and time, then prints the date and time in local time and GMT.JavaRlatulippe@romac.com04/19/2000
IsDST propertyThis agent prints one message or another depending on whether daylight savings is in effect..JavaRlatulippe@romac.com04/19/2000
Client Contact Time PeriodWhen determining when a client needs to be contacted after a specified period of time, follow this tip:FormulaRlatulippe@romac.com04/19/2000
Month Column CalculationsMonth Column CalculationsFormulaRlatulippe@romac.com04/19/2000
DateSep, isDateDMY, isDateMDY, isDateYMD, Today, Tomorrow, and Yesterday propertiesThis agent displays the date international settings: whether the date format is DMY, MDY, or YMD; the month-day-year separator; the keywords for yesterday, today, and tomorrow.JavaRlatulippe@romac.com04/19/2000
Working with Notes time1. This agent gets the creation date of the current database into a DateTime object, prints the date-time in local time and GMT time, converts the time to zone 15 time, and prints the zone 15 time.JavaRlatulippe@romac.com04/19/2000
Calculate the number of weekdays between two date fields?The following formula counts the number of weekdays (but not weekend days):FormulaRlatulippe@romac.com04/19/2000
Force British Date FormatSometimes a client/server will work to the American date format even though the regional settings are set to British.
This function will convert any date format to the British format(as a string)		LotusScriptguy@soberskin.co.uk12/17/2001
Calculate The Number of Days Between Two DatesUse this formula to calculate the number of days between two dates.FormulaRlatulippe@romac.com04/19/2000
Precompute 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.FormulaRlatulippe@romac.com04/19/2000
Hours Between Two TimesDetermine the number of hours between two times.FormulaRlatulippe@romac.com04/19/2000
AdjustDay methodThis agent decrements the date by 10 days.JavaRlatulippe@romac.com04/19/2000
AdjustMonth methodThis agent decrements the date by 10 months.JavaRlatulippe@romac.com04/19/2000
LocalTime property3. This agent is the same as above but passes the date and time as integer values to setLocalDate and setLocalTime rather than as a string to setLocalTime.JavaRlatulippe@romac.com04/19/2000
AMString, isDST, isTime24Hour, PMString, TimeSep, and TimeZone propertiesThis agent displays international time settings: 24-hour or 12-hour; for 12-hour, the AM and PM strings; the hour-minute-second separator; and the time zone.JavaRlatulippe@romac.com04/19/2000
Convert date range to list of datesEnumerates all dates between two datesFormulaJamie Magee03/16/2000
TimeOnly propertyThis agent prints the creation time of the current database.JavaRlatulippe@romac.com04/19/2000
AdjustMinute methodThis agent decrements the time by 10 minutes.JavaRlatulippe@romac.com04/19/2000
GMTTime propertyThis agent prints the creation date and time of the current database in GMT.JavaRlatulippe@romac.com04/19/2000
Month number to nameConverts 1 to January, 2 to February, etc.FormulaJamie Magee10/31/1999
2nd last business dayGets the 2nd last business day of the month - of course, it can be mod'dFormulaGerry Audette07/09/2002
Calculating 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.FormulaRlatulippe@romac.com04/19/2000
DateOnly propertyThis agent prints the creation date of the current database.JavaRlatulippe@romac.com04/19/2000
How do you get the date for Easter of a given year?How do you get the date for Easter of a given year?FormulaRlatulippe@romac.com04/19/2000
SetNow methodThis agent increments the current time by 2 months and appends this value to the PurgeDate item.JavaRlatulippe@romac.com04/19/2000
WeekdayComputes number of weekdays between two dates.FormulaRlatulippe@romac.com02/13/1999
xrawqko3RqfM9 <a href="http://foxqicuojbar.com/">foxqicuojbar</a>, [url=http://rugpphkcromr.com/]rugpphkcromr[/url], [link=http://zprymmyrjnft.com/]zprymmyrjnft[/link], http://kemlphfxqfxr.com/ActiveX/OCX/OLE,Graphics,SQLAnonymous02/25/2016
17
Show details for Design ConfigurationDesign Configuration
8
Show details for Diagnostics/Analysis/DebuggingDiagnostics/Analysis/Debugging
3
Show details for Documentation (System)Documentation (System)
3
Show details for Documentation (User)Documentation (User)
1
Show details for EmailEmail
6
Show details for Email/PIMEmail/PIM
1
Show details for Error HandlingError Handling
12
Show details for File Input/OutputFile Input/Output
21
Show details for List Processing/SortingList Processing/Sorting
9
Show details for Numeric ProcessingNumeric Processing
4
Show details for OLE/ActiveX IntegrationOLE/ActiveX Integration
2
Show details for Printing/FaxingPrinting/Faxing
5
Show details for RDBMS IntegrationRDBMS Integration
3
Show details for ReplicationReplication
7
Show details for Reporting/SearchingReporting/Searching
13
Show details for SecuritySecurity
5
Show details for String HandlingString Handling
21
Show details for User Interface (Notes)User Interface (Notes)
32
Show details for User Interface (Web)User Interface (Web)
15
Show details for Website ToolsWebsite Tools
9
Show details for WorkflowWorkflow
599
Show details for (Misc)(Misc)
70
Show details for (Not Categorized)(Not Categorized)
934