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
The easiest way to do this is to use the weekday() function. This allows you to determine the day of the week of the current date, and then you can subtract the result from 7 to determine how many days are remaining until the next Monday. Note that the second parameter of the weekday function allows you to offset the days of the week, since usually the day starts on Sunday. For example, the following expression will always give you the next Monday after the current date. Then, just use this expression in your validation to ensure that the upload is done before this date.
ri!date + 7 - weekday(ri!date, 3)
It worked for me... Thank you