Parameterised Dates in OTBI
Summary
Need to get Tax year start and end dates relative to current dateContent
I need to get the UK tax year start date (April 6th) applicable to current date, the report needs to be scheduled overnight so must not require manual intervention to set the dates, otherwise it would be easy ;-)
In the good old days I would just have created repos variables, but here I only have OTBI, I have tried some overly complicated nested statements to extract the year based on current_date but that didn't work.
OTBI is still a learning curve for me, we appear to have Cloud HCM 19A (11.13.19.01.0) and OTBI 11.1.1.9