GET WEEK NUMBER FROM CURRENT DATE

(0) Share

Report

Posted on by nagaraj007

292

Hello All,

I would want some help to get the week number of current date. I have added the below function to get the current date. If some one could help me to get the week number it would be of great help.

convertFromUtc(utcNow(),'India Standard Time','dd/MM/yyyy')

Categories:

Building flows

I have the same question (0)

All responses (27)

Answers (0)

Pstork1 68,697 Most Valuable Professional on at

Like (19)

Report
Try this formula

add(div(dayOfYear(utcNow()),7),1)

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@nagaraj007

@Pstork1 formula works 🙂.

You can also find some more ideas in the comments for the thread, https://powerusers.microsoft.com/t5/Power-Automate-Ideas/How-to-calculate-week-number-in-a-year-in-flows/idi-p/104499

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
nagaraj007 292 on at

Like (0)

Report

Will it work for all years? As I saw in one of the forums the below function works only for 2019. Please confirm. @Pstork1

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report
The function should work for any year. It is currently based on UTC. If you want it for India time zone then use this one.

add(div(dayOfYear(convertFromUtc(utcNow(),'India Standard Time','U')),7),1)

Was this reply helpful? Yes No
Amanthaper 441 on at

Like (0)

Report

edited -

Was this reply helpful? Yes No
PedrohMoreira 2 on at

Like (0)

Report

Does this also work on Power Automate Desktop?

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Power Automate Desktop doesn't use the same functions as Power Automate, so no I don't think it will work.

Was this reply helpful? Yes No
OliverR-82 619 on at

Like (0)

Report

It doesn't seem to work in 2021. It returns '21' for me today while we're currently in week 20, according to my calendar. I suppose I could replace the '1' in the formula with '2' but then it will likely not work correctly for next year, I would expect?

EDIT: or it could be because my calendar uses the ISO week number, which always starts on a Monday. That would explain. Unfortunately, that's the one I need. I'll try the method described here. It's more complex but if it does the job, then great.

Was this reply helpful? Yes No

ENRM

122 on at

Like (1)

Report

@nagaraj007

Use the WeekNum and ISOWeekNum functions to determine the week number of a date.

These functions differ in how they determine the first week of the year (week 1):

WeekNum uses the week containing January 1 as the first week of the year. The result from this function can range from 1 to 54.
ISOWeekNum uses the week containing the first Thursday of the year as the first week of the year. This follows the ISO 8601 date and time standard definition for week numbering. The result from this function can range from 1 to 53. It is possible that 52 or 53 may be returned for the first days of January since the dates could belong to the last week of the previous year.

Use the second parameter to WeekNum to specify which day begins a week. You can provide either an Excel code number or use the StartOfWeek enumeration:

1, 17	StartOfWeek.Sunday	Week begins on Sunday. Default.
2, 11	StartOfWeek.Monday	Week begins on Monday.
12	StartOfWeek.Tuesday	Week begins on Tuesday.
13	StartOfWeek.Wednesday	Week begins on Wednesday.
14	StartOfWeek.Thursday	Week begins on Thursday.
15	StartOfWeek.Friday	Week begins on Friday.
16	StartOfWeek.Saturday	Week begins on Saturday.

ISOWeekNum always uses Monday as the start of the week. In Excel, the WeekNum function supports an addition code 21 that is not supported here; use ISOWeekNum instead.

If you pass a single number to these functions, the return value is a single result. If you pass a single-column table that contains numbers, the return value is a single-column table of results, one result for each record in the argument's table. If you have a multi-column table, you can shape it into a single-column table, as working with tables describes.

Syntax

WeekNum(DateTime [, StartOfWeek ])

DateTime - Required. Date/Time value to operate on.
StartOfWeek - Optional. Excel code or StartOfWeek enumeration that determines which day the week begins.

ISOWeekNum(DateTime)

DateTime - Required. Date/Time value to operate on. The week always begins on Monday.

Was this reply helpful? Yes No

Community Power Pla... on at

Like (1)

Report

Anyone managed to get the ISO week number working?
Would love to see an example.

Was this reply helpful? Yes No