Get last date of previous month

[Hemant_Deshmukh]

how to get last date of previous month on date modify activity e.g 30/11/2023 ???

[Parvathy (PS Parvathy)]

Hi @Hemant_Deshmukh

Try this:

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

You can change the date format as required. As per your requirement

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

str_lastdate is of DataType System.String

Hope it helps!

[pravallikapaluri]

Hi @Hemant_Deshmukh

Assign activity:
DateTime lastDayOfPreviousMonth =DateTime.Now.AddDays(-DateTime.Now.Day)
Message box
lastDayOfPreviousMonth.ToString("dd/MM/yyyy")

@Hemant_Deshmukh
Cheers

[sai_gupta]

@Hemant_Deshmukh

try this :

DateTime.Now.AddMonths(-1).AddDays(-DateTime.Now.Day)

cheers…!

[lrtetala (Lakshman Reddy)]

Hi @Hemant_Deshmukh

How about the following?

Cheers!!

[neha.upase]

Hi,

you can use modify activity as below ss

Modify_Date.zip (2.7 KB)

[Kanak_Lata_Singh]

Hello @Hemant_Deshmukh

You can try to do this :
1 . Declare a variable
2 . Assign its value as n
new DateTime(now.Year , now.Month , 1).AddDays(-1).ToString(“dd/MM/yyyy”)
It will give you expected results.

[sanjay3 (Sanjay)]

Hi @Hemant_Deshmukh

How about this

lastDayOfPreviousMonth (DateTime)= New DateTime(Now.Year, Now.Month, 1).AddDays(-1)

formattedDate (String) = lastDayOfPreviousMonth.ToString(“dd/MM/yyyy”)

[Nawazish_Ahmad]

Hi @Hemant_Deshmukh

Try this:

DateTime.Now.AddMonths(-1).AddDays(-DateTime.Now.Day).ToShortDateString

For change Date Format as per your requirement.

DateTime.Now.AddMonths(-1).AddDays(-DateTime.Now.Day).ToString(“dd-MM-yy”)

Hope it will helps you
Cheers!!