I am dealing with pay periods in this situation. The bot needs to be able to select the beginning and ending of the existing pay period.
Pay periods start on saturday and end on a friday after 14 days.
I want the bot to select the highlighted period Dec 21 2019- Jan 3 Dec 2020 if it is running on any day between these two dates. Today’s date is 12/30/2019
Another example, Today is 1/2/2020 which means bot needs to select for start date 12/21/2019 and ** end date as 01/03/2020**.
Thank you for all the advice you all provide.