Hello,
We are creating an overtime request form and would like to dynamically display a start and end date of the future pay period based on the submission date in the current pay period. As well as, display a deadline date when someone can submit form, which would always be the Wednesday before the start of the future pay period.
For example:
Current pay period is 01/09/22 - 01/22/22.
Future pay period is 01/23/22 - 02/05/22.
Deadline date would be 01/19/22.
If I am filling out the form today (01/14/22) would like to display start date as 01/23/22 and end date as 02/05/22. Deadline date as 01/19/22.
I have read through date and calendar topics but nothing like our situation. Any insight on how to set this up would be greatly appreciated.
Thank you in advance!