I would like to be able run a number of reports that will always show the current Australian financial year, without having to change the find date range manually.
i.e 1st July 2015 to 30th June 2016 and so on for the next financial year.
I need the date range to automatically update depending on the current date when the user logs in.
I was thinking that I would need to use a Global field set as a DATE field g_Start and another one for the end date field g_End
I thought I would need add a SET FIELD to my opening database script to work out the current date and populate the global fields.
Using something like: set field [Rent::g_Start; Date (7;1;Year ( Get ( current date ) ))]
set field [Rent::g_End; Date (6; 30;Year ( Get ( current date ) ))+365]
I then realised this wasn't going to work..
Has anyone a solution ?