We have a need to calculate the projected sales for a company based on the current value of orders divided by a number that is the current day of the year.
I've created a property that resets on the 1st January and then increments through the year but for a company added on the 1st March for example, the starting point should be 59 rather than 1 and so on. New companies added during the year need to use the current day of the year.
I can't find a way to store the current day of the year in a company record and then use that for any new companies. Any ideas?