Thanks Stefan but the syntax does not change the date range as I wanted it to.
Here are my variables:
I have a feeling this has to do with the way I defined the vStartDate...?
My table looks like the below. with the added set analysis expression It currently ends on 31/07/2017 but starts on 31/07/2016. I want it to start from a month before today's date (e.g. 20/12/2016)