web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Date Issue On Recurrin...
Power Apps
Unanswered

Date Issue On Recurring Events

(1) ShareShare
ReportReport
Posted on by 184

Hi:

Working on a recurring event in Power Apps and the date logic calc, if it runs over to another year stops working correctly.  So, if you select a number of repeats and the below calc extends into the next year the math is wrong and are having trouble finding this.  Any help would be appreciated.

 

Here is the current code, same logic for both start and end date:

StartDate: With({FirstOfMonth:Date(Year(dtestarttime_1.SelectedDate),Month(DateAdd(dtestarttime_1.SelectedDate, Value(ThisRecord.Value -1), TimeUnit.Months)),1),DayOfWeek:varDayValue,N:drpeverynth_1.Selected.Value},
DateAdd(FirstOfMonth,(N * 7) - Weekday(DateAdd(FirstOfMonth, 7-DayOfWeek)))),
EndDate: With({FirstOfMonth:Date(Year(dtestarttime_1.SelectedDate),Month(DateAdd(dtestarttime_1.SelectedDate, Value(ThisRecord.Value -1), TimeUnit.Months)),1),DayOfWeek:varDayValue,N:drpeverynth_1.Selected.Value},
DateAdd(FirstOfMonth,(N * 7) - Weekday(DateAdd(FirstOfMonth, 7-DayOfWeek))))

 

Thank you

Chuck

Categories:
I have the same question (0)
  • Verified answer
    chtraywick Profile Picture
    184 on at
    Re: Date Issue On Recurring Events

    Hi:

    This formula is correct. just need to tweak the Value(ThisRecord.Value -0) and leave the TimeUnit.Months)),1), as is.

    Chuck

  • Alex-W Profile Picture
    315 on at
    Date Issue On Recurring Events
    Hello Chuck,
     
    Is your solution still working for you?  I tried using This.Record.Value -0 and my dates are still screwed up once the recurring event hits December and the coming year.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard