Current monthstart date going back 30 days ago

[zwyne]

Hi everyone,

PFA

I have question to ask you. On the attached sample data, I have got 3 fields. I have the following conditions: 

Issue Priority = 'Major' and  Issue Status = 'Pipeline' .So what I want to calculate is count the number of the previous condition when the  Date = '2018-10-01' and then from the Issue Creation Date check the difference of 30 days. 

i.e. Date -  Issue Creation Date (2018-09-01). So give me the number of these and in this case = 1.

So assist with this.

Thanks

[zwyne · Accepted solution]

I managed to get it correct. Thank you