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

    Set Analysis

    Ruma Barman


      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,