Lotus Domino Designer 8.5 Help

FORMULA LANGUAGE

Examples: @Adjust
1. This example returns 09/2/97.

@Adjust([06/30/95];2;2;2;0;0;0)

Lotus Notes/Domino sees 30 in the days portion of the time-date value and adjusts it by 2, which increments the month value by 1. Lotus Notes/Domino then adjusts the month value by 2, and the year value by 2.

2. This example returns 03/20/94.

@Adjust([03/30/96];-2;0;-10;0;0;0)

Notes/Domino returns a date that is 2 years and 10 days before the supplied date.

3. This example returns 09/1/97 and 09/2/97.

@Adjust([06/29/95] : [06/30/95]; 2; 2; 2; 0; 0; 0)

4. This example returns the date one month from the date in the field named Date.

@Adjust(Date;0;1;0;0;0;0)

5. This example returns the date one month and one day from the current time-date.

@Adjust(@Now;0;1;1;0;0;0)

6. Given a date, this formula calculates the beginning of the week. It takes the date stored in the dueDate field, and returns the date representing the previous Monday. For example, if dueDate is 06/02/95, this formula returns 05/29/95.

@Adjust( dueDate; 0; 0; - ( @Weekday( dueDate ) - 2 ); 0; 0; 0 )

7. This example returns 5/2/2006.

@Adjust([2/2/2006]; 0; 2; 28; 0; 0; 0)

8. This example returns 4/30/2006.

@Adjust(@Adjust([02/02/2006]; 0; 2; 0; 0; 0; 0); 0; 0; 28; 0; 0; 0)

See Also

@Adjust

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary