Date issue

[bobbydave]

If I say

=Sum( {< Country , [Control Description] = {'Claims Registered'},

   [Fiscal Year Month]= {'2016-11'>} [Record Count])

I can get the correct value ... but i am explicitly giving the date

I am trying to get the November date and i know i am doing something stupid.

Can anyone fix my [fiscal year month] below  please?

=Sum( {< Country , [Control Description] = {'Claims Registered'},

   [Fiscal Year Month]= {"$(=AddMonths(Today(), -1))"} >} [Record Count])

[vinieme12 · Accepted solution]

=Sum( {< Country , [Control Description] = {'Claims Registered'},

   [Fiscal Year Month]= {"$(=DATE(AddMonths(Today(), -1),'YYYY-MM'))"} >} [Record Count])