Get Previous Months' Last Date

[jerry.kohzl]

HI, i’m using this to obtain the last date of previous months, however the year is showing current year instead 2022; i.e. 2023-11-30

New DateTime(now.year,now.AddMonths(Period_Offset-1).Month,1).AddDays(-1).toString(“yyyy-MM-dd”)

[Anil_G]

@jerry.kohzl

@jerry.kohzl

Please try this

New DateTime(Now.Year,Now.Month,1).ADDDAYS(-1).ToString("yyyy-MM-dd")

cheers

cheers

[Gokul001 (Gokul Balaji)]

HI @jerry.kohzl

How about this expression

New DateTime(Now.Year,Now.Month,1).AddDays(-1).ToString("dd/MM/yyyy")

Regards
Gokul

[jerry.kohzl]

Hi Gokul, what parameter do I use set if I want 30-11-2022?

[Gokul001 (Gokul Balaji)]

HI @jerry.kohzl

Try with this expression

New DateTime(Now.AddYears(-1).Year,Now.AddMonths(-DaysInt).Month,1).ToString("dd/MM/yyyy")

Regards
Gokul

[jerry.kohzl]

It returned 30-12-2022

[Gokul001 (Gokul Balaji)]

@Gokul001

New DateTime(Now.AddYears(-1).Year,Now.AddMonths(-DaysInt).Month,1).ToString("dd/MM/yyyy")

Updated the post? @jerry.kohzl

[Gokul_Jayakumar (Gokul Jai)]

Hello @jerry.kohzl
Try this

DateSerial(now.Year,now.Month,0).ToString("dd-MM-yyyy")   ==> 31-12-2022

DateSerial(now.Addmonths(-1).Year,now.Addmonths(-1).Month,0).ToString("dd-MM-yyyy")    ==> 30-11-2022

[ppr (Peter)]

@jerry.kohzl

New DateTime(now.year,

here the year is fixed, and the add month will not decrease the year when the date is constructed

have a look here:

now.addDays( - now.Day + 1).addMonths(- intYourOffset + 1).AddDays(-1).toString("yyyy-MM-dd")

[jerry.kohzl]

@Gokul_Jayakumar

DateSerial(now.Addmonths(-1).Year,now.Addmonths(-1).Month,0).ToString("dd-MM-yyyy")

Thanks! This works!