I have a form that has a field, "Next Meeting Date". This field needs to auto-populate the date of the next "Tuesday". So, if the form is opened today (Monday), September 26, 2016, the field should auto-populate 9/27/2016. If the form is opened on Wednesday, 9/28/2016, it then should auto-populate the date 10/4/2016 (the next Tuesday).
Is this possible?
Thank you in advance!
Solved! Go to Solution.
Yes Andrew. Sorry I forgot to mark it. BUT, I was stuck on getting the date to format properly to which you responded and provided the extra code that it needed. Thank you again for your assistance.
Hi Michael, may I know how you formatted the date? Because I tried the code above and it gave me a very long date format, I only need the MM/dd/yyyy format. Can you help me on this?