3 Replies Latest reply: Jun 2, 2017 9:24 AM by Sunny Talwar RSS

    Set Analysis

    Ruma Barman

      Hi,

      Can anybody help?The following script is not working for Month Name(This is field with format MMM YYYY)

       

      Sum({<[Month Name]={">=$(=Date(AddMonths(vMaxDate,-2),'MMM YYYY'))<=$(=Date(AddMonths(vMaxDate,0),'MMM YYYY'))"}>} Data)

       

       

      whereas it works for Link_Date(This is a field with format DD/MM/YYYY)

      Sum({<Link_Date={">=$(=Date(AddMonths(vMaxDate,-2),'DD/MM/YYYY'))<=$(=Date(AddMonths(vMaxDate,0),'DD/MM/YYYY'))"}>} Data)

       

       

      Thanks and Regards,

      Ruma