Damon Posted May 4, 2023 Posted May 4, 2023 Hi all, When adding custom report columns with date range filters such as the attendancecode counts, the relative date filter provides options like this year, currentterm and last term. Can anyone confirm if all these dates stay relevant to the report rundate when running through the live link or are they frozen based on when thereport was created/modified? For example, if I create the report in sept andset it to 'this term', if I run it in July via the live link, will it give methe summer term data? Thanks for your help
syan Posted May 16, 2023 Posted May 16, 2023 Late reply but yes, those sort of date range options do seem to be relative and not fixed on the day the report was created. I've not used the 'Current term' option myself but have used 'Today', which dynamically changes the date range to the day you are on; a bit like =TODAY in Excel. So, if I created an attendance report on the 1st May with 'Today' and viewed that same report on 16 May, the data is reflective of 16 May, not 1 May.
Damon Posted June 10, 2023 Author Posted June 10, 2023 Thanks a lot for responding. That's what I needed to hear! Now I can crack on with this report without any issues 👍
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now