https://community.blueprism.com/t5/Product-Forum/problem-filter-calculation/m-p/98525#M46256 <P>I need to filter the collection to git the data<BR /><span class="lia-inline-image-display-wrapper" image-alt="35882.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/35896i8515379738CEC581/image-size/large?v=v2&amp;px=999" role="button" title="35882.png" alt="35882.png" /></span></P> <P><span class="lia-inline-image-display-wrapper" image-alt="35883.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/35897iDE5318D16BF4D1A7/image-size/large?v=v2&amp;px=999" role="button" title="35883.png" alt="35883.png" /></span></P> <P>what is the problem&nbsp; in expression? How I can Write it</P> Mon, 18 Sep 2023 13:38:51 GMT faheddalla 2023-09-18T13:38:51Z https://community.blueprism.com/t5/Product-Forum/problem-filter-calculation/m-p/98525#M46256 <P>I need to filter the collection to git the data<BR /><span class="lia-inline-image-display-wrapper" image-alt="35882.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/35896i8515379738CEC581/image-size/large?v=v2&amp;px=999" role="button" title="35882.png" alt="35882.png" /></span></P> <P><span class="lia-inline-image-display-wrapper" image-alt="35883.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/35897iDE5318D16BF4D1A7/image-size/large?v=v2&amp;px=999" role="button" title="35883.png" alt="35883.png" /></span></P> <P>what is the problem&nbsp; in expression? How I can Write it</P> Mon, 18 Sep 2023 13:38:51 GMT https://community.blueprism.com/t5/Product-Forum/problem-filter-calculation/m-p/98525#M46256 faheddalla 2023-09-18T13:38:51Z https://community.blueprism.com/t5/Product-Forum/problem-filter-calculation/m-p/98526#M46257 <P>Hi <A href="https://community.blueprism.com/network/profile?UserKey=29547be2-9bb3-4b24-9be7-390ffa30ae64" target="" class="author" aria-label="Mohammed Fahed Dalla Press space to toggle pop up" aria-haspopup="dialog" aria-controls="bio-bubble-popup-29547be2-9bb3-4b24-9be7-390ffa30ae64-3">Mohammed Fahed Dalla</A>,</P> <P> </P><P>You can&nbsp; write the expression some thing like this "date LIKE '*"&amp; [Current date in Month and year]&amp;"*'"<BR /><BR />Check below threads&nbsp; it will help to write the filters and it has examples as well.<BR /><SPAN><A href="https://learn.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?view=netframework-4.7.2" target="test_blank">https://learn.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?view=netframework-4.7.2</A></SPAN><BR /><SPAN><A href="https://www.csharp-examples.net/dataview-rowfilter/" target="test_blank">https://www.csharp-examples.net/dataview-rowfilter/</A><BR /><BR /></SPAN><BR /><BR />I have tested the expression check below screenshots for reference<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="35878.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/35888i67F38600CDAA57CC/image-size/large?v=v2&amp;px=999" role="button" title="35878.png" alt="35878.png" /></span><BR /><span class="lia-inline-image-display-wrapper" image-alt="35879.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/35892i6A225008C349E64C/image-size/large?v=v2&amp;px=999" role="button" title="35879.png" alt="35879.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="35880.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/35895i7AF8AB6525384230/image-size/large?v=v2&amp;px=999" role="button" title="35880.png" alt="35880.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="35881.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/35893iB48E24E8F706B80D/image-size/large?v=v2&amp;px=999" role="button" title="35881.png" alt="35881.png" /></span><BR /><BR /></P> Mon, 18 Sep 2023 14:11:33 GMT https://community.blueprism.com/t5/Product-Forum/problem-filter-calculation/m-p/98526#M46257 harish.mogulluri 2023-09-18T14:11:33Z