Number days financial year

Templates Reports
1

Hello,

Is it possible to calculate in a formule the number of days of the financial year?

If yes, how?

I already tried to use as formule (period.year_end_date-period.year_start_date)+1 but the result is 1 and not 365.

Thanks,

Sylvie

2

Hi Sylvie,

the code below should work to calculate the number of days of the financial year:

{% assign total_days_in_book_year = period.year_end_date-period.year_start_date+1 %}

Michiel

3

Hallo,

The formule {% assign total_days_in_book_year = period.end_date-period.year_start_date+1 %} does not work in a report.

Do you have a solution for me?

Thanks,

Sylvie

4

Hi Sylvie,

Why would you like to calculate the number of days in a report? Currently we do not support this. Would it be possible in your case to first use the formula in a reconciliation template, do some calculation with it and then show the result of this calculation in your report?

Kind regards,

Michiel