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

[VS325]

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)

[gabibalaban · Accepted solution]

Hi @VS325 ,

Just a thought, use:

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

Hope it helps !

[VS325]

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
)

[gabibalaban]

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