You need to sign in to do that
Don't have an account?
Samuel 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
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