Last day variable of current month

[Guilherme_Silva]

hello, would anyone know how can i get the last day of the month, of the current month, and be able to put that date in a spreadsheet without losing the dd/MM/yyyy formatting ?

[prasath17 (Guru)]

@Guilherme_Silva - Please try as shown below…

StrLastDateCurMonth = new Datetime(now.year,now.AddMonths(1).month,1).AddDays(-1).ToString("dd/MM/yyyy")

Hope this helps…

[ppr (Peter Preuss)]

As an alternate:
Working on June

Failling on July

Thanks to @prasath17 he fixed with:

Thanks for the catch

[Guilherme_Silva]

thank you so much

[Guilherme_Silva]

very good, thanks