Get date the Last day of next month

Help
1

How to get the last day of next month??

ex) today is 13-May-2019, want last day of June
want to get form like dd-MMM-YYYY

2

Hi @dlawoals,

Please find the below methods. First method will be the right approach I guess.

Method 1:

today.AddDays(-(today.Day-1)).AddMonths(2).AddDays(-1).tostring("dd-MMM-yyyy")

Method2:

datetime.DaysInMonth(today.AddMonths(1).Year,today.AddMonths(1).Month) + today.AddMonths(1).tostring("-MMM-yyyy")

Please refer this link for your reference.

6 Likes
3

Use the code below.

Dim reference As DateTime = DateTime.Now
Dim firstDayThisMonth As New DateTime(reference.Year, reference.Month, 1)
Dim lastDayNextMonth As String = firstDayThisMonth.AddMonths(2).AddDays(-1).ToString("dd-MMM-yyyy")

Working sample: Find last day of next month, Visual Basic - rextester

One liner

Dim lastDayNextMonth As String = New DateTime(DateTime.Today.Year, DateTime.Today.Month, 1).AddMonths(2).AddDays(-1).ToString("dd-MMM-yyyy")
4

hi @dlawoals,

I tried your problem you asked for. The following code seem to work
New datetime(now.Date.Year, now.Date.Month,1).AddMonths(2).AddDays(-1).ToString(“dd-MMM-yyyy”, System.Globalization.CultureInfo.InvariantCulture)

hope it helps

Regards

1 Like
5

really helpful me thank you!!

6

thank you for your solution :slight_smile:

7

It works now thank you:)

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.