![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/36144711077/original/u0ROqHbTP4B-s2xYNHxENmK2_CGBFbc43w.png?1671059373)
Please use the below filter
canceldate between 2019-12-31 and 2020-01-31 and closed='N' and terms='2%R3'
Note: Use the cancel date which you desired to get the result and make sure the date format is YYYY-MM-DD
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/36144711079/original/GmR8e6PC_vgim2QPBQ3gPzer0NwxZZze7Q.png?1671059373)
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/36144711080/original/9bHVOdkQ1zOVAsJn2cztCihFNSHmtp-USQ.png?1671059373)
Modified on: Wed, 14 Dec, 2022 at 3:10 PM
Did you find it helpful? Yes No
Send feedback