+ Start a Discussion
Manjeet VermaManjeet Verma 

What is the formula of getting Current month first date and current month last date ?

What is the formula of getting Current month first date and current month last date ?
Best Answer chosen by Manjeet Verma
Malika Pathak 9Malika Pathak 9

Hi Manjeet,

Find the below Solution

First day of the current month:

DATE(YEAR(TODAY()), MONTH(TODAY()),1)

Last day of the current month:


DATE(YEAR(TODAY()),MONTH(TODAY()) + 1,1) - 1

If you find this helpful mark it as the best answer.

All Answers

VinayVinay (Salesforce Developers) 
Hi Manjeet,

For the first day of the current month:
DATE(
     YEAR(TODAY()),
     MONTH(TODAY()),
     1
)

For the last day of the current month:
DATE(
     YEAR(TODAY()),
     MONTH(TODAY()) + 1,
     1
) - 1

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Malika Pathak 9Malika Pathak 9

Hi Manjeet,

Find the below Solution

First day of the current month:

DATE(YEAR(TODAY()), MONTH(TODAY()),1)

Last day of the current month:


DATE(YEAR(TODAY()),MONTH(TODAY()) + 1,1) - 1

If you find this helpful mark it as the best answer.

This was selected as the best answer
KMK91KMK91
What is the formula of getting Current month  ?
should be return 1(Ex : Apr) and 2nd Month(May) sould return 2 value