HFRS - How to generate Date Format for a report Dimension - Accounting Period on report Header
We have a requirement where the HFRS Report header needs date format of the Accounting Period.
Our Accounting Period Format is MMM-YY and this is a Dimension in the report.
We can pull it in the Header text via Member Description Function which appears as MMM-YYYY.
However the requirement is to display the last date of the month as the report header and show it in the format dd-mm-yyyy format. e.g. 30-10-2023.
Please let me know if someone is able to meet this requirement.