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

How to add last day of next month as default date?

Can someone please help me on how to add last day of next month as a default date? I already have first day of next month set as - Date(Year(Today()), Month(Today())+1, 1)

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Hi @VS325 ,

Just a thought, use:

DateAdd(
     Date(Year(Today()), Month(Today())+2, 1),
     -1,
     Days
)

 

Hope it helps !

View solution in original post

3 REPLIES 3
Super User II
Super User II

Hi @VS325 ,

Just a thought, use:

DateAdd(
     Date(Year(Today()), Month(Today())+2, 1),
     -1,
     Days
)

 

Hope it helps !

View solution in original post

Helper I
Helper I

Thank you so much. Yes that works. I tried this also which works. 

 

DateAdd(
DateAdd(
Date(
Year(Today()),
Month(Today()) + 1,
1
),
1,
Months
),
-1,
Days
)

Yes, is the same logic. But you do an extra operation. 😊

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (65,285)