Unanswered

How to get numeric day of week from date

(0) Share

Report

Posted on by bitshift

Given a Date or DateTime, the DayOfWeek property gives a text value eg. Friday, whereas I need the integer value. Where is that?
What Im trying to do is get the Sunday date for the current week, so I supposed it would be:
CurrentDate - DayOfWeek

help?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (12)

Answers (0)

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@bitshift

dayOfWeek() actually does return an integer. Sunday is 0 and Saturday is 6

If you are looking for the previous Sunday, see my example below:

Was this reply helpful? Yes No

bitshift

12 on at

Like (0)

Report

Copy link

Link copied!

Sorry I wasnt clear, this is regarding PAD - power automate desktop
Datatype properties - Power Automate | Microsoft Docs

Dates

DATESProperty Description

Year	The year part of the datetime value.
Month	The month part of the datetime value.
Day	The day part of the datetime value.
DayOfWeek	The name of the day (Sunday, Monday etch).
DayOfYear	The day of the year part of the datetime value (1-365/6).
Hour	The hour part of the datetime value.
Minute	The minute part of the datetime value.
Second	The seconds part of the datetime value.

Was this reply helpful? Yes No

MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

Do you need Power Automate Desktop or Power Automate, like @ScottShearer is using?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

I would use a Switch:

Switch %dayofweek%
Case “Sunday”, %result% = 1
Case “Monday”, %result% = 2
and so on
End (Switch)

Was this reply helpful? Yes No
bitshift 12 on at

Like (0)

Report
Copy link

Link copied!

Why is there a difference between power automate cloud and desktop, or am i missing something?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

Here is some input from other users: https://powerusers.microsoft.com/t5/General-Power-Automate/Power-Automate-Cloud-vs-Desktop/td-p/792484

Personally, I think PAD is easier to use, bot the online version has more capability, such as triggers being able to occur from online activity. Ex. it taps into your outlook and says "when I receive an e-mail from so-and-so, do this."

In PAD, you would have to trigger the flow manually (or schedule a flow to run systematically), and you could say, "check all unread messages for an e-mail from so-and-so, and do this."

So, PAD is a little limited in that manner. I think the best is to learn both. PAD might be better to learn first to take care of your local processes on your own workstation.

Was this reply helpful? Yes No
bitshift 12 on at

Like (0)

Report
Copy link

Link copied!

I was able to accomplish what I needed with a switch. What a pain! Would be nice to have the numeric value available from DayOfWeek or something similar

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

You might find this interesting too; it was for "last Friday", but you could easily change that to "last Sunday", if you always need last Sunday's date.

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Append-Text-to-File-Name-in-Save-As-box/m-p/1356751#M8738

Was this reply helpful? Yes No
Highboy 1,185 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

There are many ways to accomplish this, and one is using the power of Powershell.
You can feed the "run powershell scupt" with any date and get the weeknumber.
Dateformat to feed the powershell script is MM/dd/yyyy

Was this reply helpful? Yes No
AlexScharpé 35 on at

Like (1)

Report
Copy link

Link copied!

I am currently experiencing the same problem in PAD where I need to find the numeric week we are in. An out of the box solution I might go for is to visit a website like https://www.epochconverter.com/weeknumbers and spy the week number as a UI element. You could try the same with the day number..

Was this reply helpful? Yes No