Year to date function

[#1]

I wish to add a year to date function to one of my expressions, but rather then it running from the current date I would like it to run from July. Is there any way that I am able to do this?

Thanks

[Gysbert_Wassenaar · Accepted solution]

Try something like this to get this years sales upto and including July:

sum({<Year={'$(=year(today())-3)'},Month={'<=7'} >} Sales)

This assumes you have a Year and Month field (and a Sales field)

[OmarBenSalem]

Hi Gysbert,

the -3 in the expression "year(today())-3)", what is that for?