Calculate with dates

[Julie_Vandekerckhove]

{% fori liq in custom.bijzonder_liquidatiereserves %}{% assign $1 = 0 %}
Bijzondere liquidatiereserve over {% input liq.boekjaar %}, aangelegd in boekjaar {%input liq.boekjaar_aangelegd as:date placeholder:‘afsluitdatum’ %} en voordelig uit te keren vanaf {{ liq.boekjaar_aangelegd+1830 }} {% input liq.datum as:date placeholder:‘datum’ %}: € {% input liq[liq.boekjaar] as:account_collection range:13 accounts_var:bijz_liq_rek %}{{ -1*bijz_liq_rek | currency }}

In the code above I need to ad 5 years and one day to the date liq.boekjaar_aangelegd (=±1830 days). How do you ad or subtract years or days?

[sven]

Hey @Julie_Vandekerckhove,

The answer can be found here :

How to retrieve historical information in details

@Bart_Verhaeghe, Where do you want to retrieve this information? In the account template, or do you want to retrieve it somewhere else? Part of your solution is in here, if you want to retrieve it somewhere else. And I don’t get your example; shouldn’t it be 100+50+60 = 210? Whatever your object is where that data is stored for each stock movement, you’ll need to go over your collection again with a for-loop, and put an if-statement in there that adds the cumulative amount in a re…

Let us know if it worked for you?