Unanswered

Calculate the week number of current date within a month

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

Is it possible to calculate the current week number within a month? I know that

add(div(dayOfYear(utcNow()),7),1) returns the week number within a year. What I want to know is how to return the week number within the month. For instance todays date 15th november should return Weeknumber = 2 since it is the second week of november.

Please let me know if there is a solution to get this.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

mahoneypat 1,720 on at

Like (0)

Report

Please try this expression

formatNumber(div(dayOfMonth(utcNow()),7), '0')

Pat

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @Anonymous,

Do you want to get the week number of today?

You just need to modify your formula as below:

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

This worked. Thankyou!

Was this reply helpful? Yes No