web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Get Month name from We...

Power Apps

Unanswered

Get Month name from Week number

(0) Share

Report

Report

Posted on by Rene_Newbee

106

Hi all you experts

I have a text label with a Week Number and I need to get the corresponding Month Name in another text label, is that possible?

The text label is just a text label with a number between 1 and 52.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

SoPatt Microsoft Employee on at

Like (0)

Report

Is Week 1 the first 7 days of the year, Week 2 the second 7 days, etc.? You'll going to need a 53 because 7x52=364 which means there are 1-2 days in Week 53 of any given year. Is this always going to be for the current year, or is the year user-selected?

Was this reply helpful? Yes No
Rene_Newbee 106 on at

Like (0)

Report

Yes week 1 is always the first week of the year. It will always be for the current year.

Was this reply helpful? Yes No
Verified answer

SoPatt Microsoft Employee on at

Like (0)

Report
If TextInput1 contains the number of the week then this will give the name of the month containing the first day of that week:

Text(Date(Year(Today()),1,Value(TextInput1.Text)*7-6),"mmmm")

Was this reply helpful? Yes No

Join the conversation