Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

Date issue

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])

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

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

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

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

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.