Display the data of the current month

[Black_Hole]

Hello all,

I try to display the data of the current month from my straight table using only "expression".

So, I wrote the following expression:

=if(MonthName(addmonths(today(),-1))<=DATE,Custom)

But, my criteria is not considered.

Please could you advise me how I can display only the data from the current month using expression.

Thank you in advance for your help.

[Vegar]

[Black_Hole]

Hello @Anonymous , @Vegar ,

Thank you both of you for your help.

@Vegar : I tried it and it's almost perfect. Indeed, the expression returns the count of the data with the maximal date. In other words, I have a count of the data for the last day saved in my database (in my case it's the 20190525).

Please could you tell me what I can add in the expression in order to consider the maximum month (YYYYMM) and not the maximum date (YYYYMMDD).

I hope it's clear...

Thank you in advance for your help.