but the problem with this is that is keeps searching and it is running really slow. I was told to make an agent with an Evaluate function using @businessdays in there. I need create an agent that will get me how many days old field. I need to improve this agent to get it to loop through my view I have and calculate the days between (DateCreated and DateClosed) sometimes they are not closed yet so they would need to use today's date and the date created to get the days in between. So this is what I have so far.... I need Ideas of where to go from here
ps. my field is set to computed when composed and is called daysold
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!