Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Expressions

Date expressions

Date Expressions change dates related to financial periods, such as current year, prior year, start and end dates, and formatting options.
note
The following lists common expressions to help you automate data in ONESOURCE Statutory Reporting for an entity or template. This is a reference guide, and doesn't include all expressions. Contact Thomson Reuters Support if you need more help with expressions.
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.

This article applies to:

  • PRODUCT: ONESOURCE Statutory Reporting