Get date of next upcoming Saturday

Like (0) Share

Report

Posted on 19 Oct 2023 18:59:53 by Murphys110

As part of a PAD flow, I'd like to be able to populate a date field with the date of the next upcoming Saturday. For example, if today is Thursday 10/19/23, I'd like to have PAD input 10/21/23. Would need a solution that would work regardless of current day of week.

Thanks for any help!

All responses (7)

Answers (1)

Verified answer

Agnius Bartninkas 10,045 Most Valuable Professional on 20 Oct 2023 at 10:33:18

Like (2)

Report
Re: Get date of next upcoming Saturday

An alternative method to what @MichaelAnnis suggested is using the .DayOfWeek property of a date time variable.

You can build a loop that increases your current date by 1 day and then checks the .DayOfWeek property of the resulting day. If it is equal to Saturday, you can exit the loop.

It would look like this:

Here's a snippet you can paste into PAD:

DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime LOOP WHILE (CurrentDateTime.DayOfWeek) <> ($'''Saturday''') DateTime.Add DateTime: CurrentDateTime TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> CurrentDateTime END

Please note that the value of the .DayOfWeek property is localized. So, if your PAD is not English, you need to translate the "Saturday" in the loop to the appropriate name of the day in your language.

When the loop is done, your %CurrentDateTime% variable will hold the next Saturday.

You can also have a separate variable, if you don't want to overwrite %CurrentDateTime%, by adding a single Set variable action before the loop. I just wanted to show you how it can be done with as few actions as possible.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.