function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Shahil Khan 1Shahil 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)