How to get current month data

[mnvrma]

Sum({<AmountCr={">0"},CommenceMonth={'$(VCurrentMonth)'}>}AmountCr)

I'm getting whole year data but i want only Current month Data..

Please help here.

[Taoufiq_Zarra · Accepted solution]

I think we just need to check the date format.
Does CommenceMonth and VCurrentMonth have the same format ?

[benoitgochel · Accepted solution]

Hi, 

What is your variable VCurrentMonth? 

Should be something like "Month(Today()) ".

Are you also sure you have a good filter on the year? Your month has to be a combinaison of the month and the year in order to only get, for instance, the december of this year and not all the decembers in your data. 

Regards,