cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How To Get Next Month

Hello All,

 

 

I would like to know if there is how to get the next month.

 

I try to use Month(Today()) + 1. But i have one problem with month of dezember. Where the next month will be 13 and not 1

 

Tks For All

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Power Apps
Power Apps

Re: How To Get Next Month

I would use DateAdd for that, something like
Month(DateAdd(Today(), 1, Months))

View solution in original post

Highlighted
Community Champion
Community Champion

Re: How To Get Next Month

Hi @Moises

 

As @carlosag mentioned, I would recommend to look at

https://powerapps.microsoft.com/en-us/tutorials/function-dateadd-datediff/

as there have a lot of useful yet short and precise function for date.

 

Hope this helps.

hpkeong

View solution in original post

2 REPLIES 2
Highlighted
Power Apps
Power Apps

Re: How To Get Next Month

I would use DateAdd for that, something like
Month(DateAdd(Today(), 1, Months))

View solution in original post

Highlighted
Community Champion
Community Champion

Re: How To Get Next Month

Hi @Moises

 

As @carlosag mentioned, I would recommend to look at

https://powerapps.microsoft.com/en-us/tutorials/function-dateadd-datediff/

as there have a lot of useful yet short and precise function for date.

 

Hope this helps.

hpkeong

View solution in original post

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,245)