Hello All,
I have a requirement that status need to be updated until following Monday.
We will upload spread sheet on Every Monday or Tuesday or Wednesday. While uploading it will check the date(it is a column in spread sheet) current date and previous date records will be updated to New Status. Now the requirement is it should be validated previous dates, current date and until following Monday records.
We are able to achieve previous dates and current date. How to get following Monday date as we are not sure about the file upload week date.
For example: On 08.12.2021 If I upload the file it should be validated on or before 08.12.2021 and until following Monday(08.16.2021).
On 08.11.2021 If I upload the file it should be validated on or before 08.11.2021 and until following Monday(08.16.2021)
Please Suggest.
Thank you
Discussion posts and replies are publicly visible