Selection of Friday Date

5 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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 )

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • shivasanjay
    @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.
    2,525 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following