How to round off the date 28/01/2022 to 31/01/2022?

Help Activities
, ,
1

I need to process date in the format of “28/01/2022” into “31/01/2022”
i.e: Last date of the given date month.

Can any one please give suggestion fro this use case.

Thanks
Kiruthika

2

we can dynamicaly calculate the end month date by following:
grafik
YourDateTimeVar.AddDays(- YourDateTimeVar.Day + 1).AddMonths(1).AddDays(-1)

1 Like
3

HI,

FYI, another approach:

yourString = "28/01/2022"

Then

System.Text.RegularExpressions.Regex.Replace(yourString,"(\d+)/(\d+)/(\d+)",Function(m) DateTime.DaysInMonth(CInt(m.Groups(3).Value),CInt(m.Groups(2).Value)).ToString()+"/"+m.Groups(2).Value+"/"+m.Groups(3).Value)

Regards,

4

@ppr Thanks its working fine

5

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