Last day of last month

Help Activities
1

I want to write last day of last month. Example 31-10-22. Could anyone please kindly help.

2

HI @Sabbir_Anwar

Try with this expression

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

Regards
gokul

3

image

4

Hi

How about the following?

New DateTime(Now.Year,Now.Month,1).AddDAys(-1).ToString("dd-MM-yy")

Regards,

5

Hello @Sabbir_Anwar
Try this

DateSerial(now.Year,Now.Month,0).ToString("dd-MM-yy")

image

1 Like
6

@Gokul_Jayakumar Thanks a lot

7

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