+ Start a Discussion
Samuel Gonsalves 8Samuel Gonsalves 8 

Analyse current month and last month for reporting based on start date and end date in salesforce

Hi Team,

I have two fields "Start Date" and "End Date". Everytime my Start dates and End date will be like 1/1/2015 to 31/12/2015 or 1/1/2015 to 30/12/2015 depending on days in a month. I want to create report based on current month and last month as filters. For eg :
Todays date is 2/9/2015 (So current month is sept),
In this case it should only take Start date = 1/9/2015 and End Date=30/9/2015 in current month and Start date = 1/8/2015 and End Date=31/8/2015 as Last month reporting.

Can anyone have any suggestion how i can acheive this? Need urgently
Thanks

Regards,
Samuel