web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Get the second sunday ...

Power Apps

Answered

Get the second sunday date of march for the current year

(1) Share

Report

Report

Posted on by KDAI

172

I am trying to get the date for second Sunday of march month

Set(

varmarchsecondsunday,

Date(

Year(Today()),

3,

Day(2)

)

)

i get the 31 of the current year.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
// Set the year and month for which you want the second Sunday Set(gloYear, 2024); Set(gloMonth, 3); // Example: March 2024 // Calculate the first day of the month Set(gloFirstDayOfMonth, DateValue(gloYear & "-" & gloMonth & "-1")); // Determine the day of the week for the first day of the month (0=Sunday, 1=Monday, ..., 6=Saturday) Set(gloFirstDayOfWeek, Weekday(gloFirstDayOfMonth) - 1); // Calculate the second Sunday // If the first day is Sunday, the second Sunday will be 7 plus the first day of month, otherwise calculate the second Sunday by adding the number of days needed Set(gloSecondSunday, If( gloFirstDayOfWeek = 0, DateAdd(gloFirstDayOfMonth, 7, TimeUnit.Days), DateAdd(gloFirstDayOfMonth, 14 - gloFirstDayOfWeek, TimeUnit.Days) ) ); Set( varmarchsecondsunday, gloSecondSunday )

Was this reply helpful? Yes No

Join the conversation