To find last day of month from "DEC-21"

[Divya123 (DT)]

Hello All,
I have an input string variable with value “DEC-21”, how do i get the last date of the given “month-yy” ie 12-31-2021.

Please advice.

Thanks

[prasath17 (Guru)]

@Divya123 - Please try as shown below…

datetime.ParseExact("DEC-21","MMM-yy",System.Globalization.CultureInfo.InvariantCulture).AddMonths(1).AddDays(-1).tostring("MM-dd-yyyy")

Here is the step by step construct of the code…

You see, first datetime.parseexact will get the first day of the month, so to get the last date add the month plus 1 and then subtract day by 1 from that...

Hope this helps…

[Divya123 (DT)]

@prasath17

datetime.ParseExact("DEC-21","MMM-yy",System.Globalization.CultureInfo.InvariantCulture).AddMonths(1).AddDays(-1).tostring("MM-dd-yyyy")

Thanks alot it worked , i get the result for “mar-21”…03/31/2021…how can i get it like “3/31/2021”…without zero …like “1/30/2021”

[prasath17 (Guru)]

@Divya123 - Instead of MM just use to M. Same goes for dd also…

So it should be M-dd-yyyy or M-d-yyyy, because dd or d does not matter in your case since the last day of the month always be two digits…

[Divya123 (DT)]

Thanks Prasath ! that worked