CASE transactions drop: check which costs could be marked as an investment

Hi @MID,

You could make the list work with the current period only like this:

{% assign begindate_current = period.minus_1p.end_date+1 | date:"%s" %} 
{% assign enddate_current = period.end_date | date:"%s" %} 

In above code we create 2 variables (begin date and end date of the current period) which we’ll need in our for-loop.

The “%s” expresses a date in a certain number, so it’s easier to compare dates without having to format dates (transaction date can be like 01/02/2018 while the date of the period is 2018-03-31)

In the forloop we’ll express the date of the transaction like this too:

{% assign tr_date = tr.date | date:"%s" %}  

If you have these, you can create an if-statement like this within the forloop:

{% if tr_date > begindate_current and tr_date < enddate_current %} 
... 
{% endif %}

Could this work for you?