You need to sign in to do that
Don't have an account?
Shahil Khan 1
Number of days into the quarter & Close date result in Quarter and Year
Hello Everyone,
I am trying to create an opportunity report to track how much business is closed on a daily basis.
For this i need to create two custom fields but i am having a hard time figuring out the logic that would go behind these formula field so i thought i'd reach out to the experts!
Here are the details of the required fields;
1) Day of Quarter: Number of days into the quarter (e.g. Jan 2 is 2 days into the quarter (Q1), similarly Apr 2 is also 2 days into the quarter (Q2)). The output for both days is 2.
2)Contract Close Date: Shows the Quarter and Year of Contract Close Date (e.g. 2019 Q2)
I am trying to create an opportunity report to track how much business is closed on a daily basis.
For this i need to create two custom fields but i am having a hard time figuring out the logic that would go behind these formula field so i thought i'd reach out to the experts!
Here are the details of the required fields;
1) Day of Quarter: Number of days into the quarter (e.g. Jan 2 is 2 days into the quarter (Q1), similarly Apr 2 is also 2 days into the quarter (Q2)). The output for both days is 2.
2)Contract Close Date: Shows the Quarter and Year of Contract Close Date (e.g. 2019 Q2)