cancel
Showing results for 
Search instead for 
Did you mean: 

How to show first day of current month last year

Former Member
0 Kudos

Hi. I am using the formula below to show 1st day on month. How can I modify this to show 1st day of current month last year?

date(year(currentdate),month(currentdate),1)

Regards,

Fraser

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Fraser,

Modify it to:

date(year(currentdate)-1,month(currentdate),1)

-Abhilash

Former Member
0 Kudos

Perfect. Thank you.

Answers (0)