Home > IT Answers > Lotus Domino > Selection of Friday Date
R4
5 pts.
 Selection of Friday Date
Lotus calendar, Lotus Designer
In lotus designer how we can Select only friday dates in Calender/Time control? (for eg. if we select tuesday date corresponding week's friday date should be selected.)

Software/Hardware used:
Lotus Designer
ASKED: March 29, 2012  10:20 AM
UPDATED: May 10, 2012  8:36 AM
RELATED QUESTIONS
Answer Wiki:
Not really sure what you're looking for here, but I'll take a guess. If the user selects a date (using a calendar control), you want to automatically adjust the date to that week's Friday. You can do that by setting the date to @Adjust( datefield; 0; 0; 6 - @Weekday( datefield ); 0; 0; 0 )
Last Wiki Answer Submitted:  March 30, 2012  3:23 pm  by  Stiletto   2,700 pts.
All Answer Wiki Contributors:  Stiletto   2,700 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

@weekday (date) returns the day No. i.e. 1 for sunday, 2 for Monday ….7 for Saturday.
Thus suppose some one selects tuesday, then we can apply @weekday(date) to get the week no. here in this case we will get 3. and to get friday it should be 6 thus if selected no comes less than 6 then we get calulation as 6- return day. if user selects a date and returns 7 then we use 7-6 ie. 1 , then we use formula @adjust to find the week’s friday.

shivasanjay
 1,055 pts.