OBI Reporting - Formulas for Time Sensitive Reporting
SummaryNeed help with creating time/date sensitive filters
I will be the first to admit that I am not the most savvy when it comes to reporting in OBI. We are still transitioning some of our more complicated BO reports to OBI. I am having trouble recreating some of these reports that are filtering out data based on action dates. For example, we have multiple reports that are pulling information based on hire date. In BO, I could add the filter for the Job Offer - Actual Start Date field so that the report would pull any start dates that are greater than or equal to 12 months ago. In BO it was much easier for me since the prompt could be selected, but it appears now that I will have to create the prompt. Any recommendations on how to do this?