cancel
Showing results for 
Search instead for 
Did you mean: 

problem filter calculation

faheddalla
Level 2

I need to filter the collection to git the data
35882.png

35883.png

what is the problem  in expression? How I can Write it

1 REPLY 1

Hi Mohammed Fahed Dalla,

You can  write the expression some thing like this "date LIKE '*"& [Current date in Month and year]&"*'"

Check below threads  it will help to write the filters and it has examples as well.
https://learn.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?view=netframework-4.7.2
https://www.csharp-examples.net/dataview-rowfilter/



I have tested the expression check below screenshots for reference

35878.png
35879.png35880.png35881.png

-----------------------
If I answered your query. Please mark it as the Best Answer

Harish Mogulluri