Date expressions

Date Expressions change dates related to financial periods, such as current year, prior year, start and end dates, and formatting options.
Expression
Description
reportHelper.CurrentPeriod.EndDate.Value.Year
Current year of the financial period.
reportHelper.CurrentPeriod.EndDate.
Value.ToString('d MMMM yyyy')
Current year-end date of the financial period in the format 'd MMMM yyyy'. Update the highlighted string to change the date format.
reportHelper.ComparativePeriod(1).EndDate.
Value.Year
Prior year of the current financial period.
reportHelper.ComparativePeriod(1).EndDate.
Value.ToString('d MMMM yyyy')
Prior year-end date of the financial period in the date format 'd MMMM yyyy'. Update the highlighted string to change the date format.
reportHelper.CurrentPeriod.StartDate.
Value.ToString('d MMMM yyyy')
Current year start date of the financial period in the format 'd MMMM yyyy'. Update the highlighted string to change the date format.
reportHelper.ComparativePeriod(1).StartDate.
Value.ToString('d MMMM yyyy')
Prior year start date of the financial period in the format 'd MMMM yyyy'. Update the highlighted string to change the date format.
reportHelper.CurrentPeriod.EndDate.
Value.AddYears(1).Year
Subsequent year relative to the current financial period. For example, if the current period date is 31 December 2022, this expression will return '2023'. Replace '.Year' with '.ToString('d MMMM yyyy') to get the full end date of the next financial year (for example, 31 December 2023).
Convert.ToDateTime
(reporting.queries.client.lookupaccountingperioddata
("Disclosure|
General|
FinalisationDates|
FinalisationDates|
Directors|
Current Period")[0].Value).AddYears(1).ToString('d MMMM yyyy')
In some cases, you can calculate the date 1 year from the signing of the financial statements. This expression fetches the signing date, converts it to a DateTime value, adds 1 year, and presents it in the desired format. The highlighted string applies specifically to UK/ROI content.