I need to create a derived property that functions as a quarter (Q1, Q2, Q3, Q4). Instead of January 1st through March 31st being Q1, I want it to be something like January 15th through April 8th is Q1. I could make that happen with an IF statement but I am having trouble in finding the right property to feed to the function that could process this calculation.
The best I have found so far is the server upload time property, but I can’t seem to figure out the date format of that property in the analysis tool to be able to correctly calculate what I need. Do you know the format of it or a better way in which I could achieve the above?
Best answer by rafaelduperronView original