5 Replies Latest reply: Jan 6, 2015 11:36 AM by Rob Wunderlich RSS

    Calendar Script (This month a year ago)

    stuart wannop

      Hi All


      I've had a search through various threads but can't quite find what I want. I have a calendar script set up to return 1 or 0 for various date conditions but I'm missing a couple and I hope someone can help.


      So far I have:


      if(InYearToDate (Date, today(),0,4),1,0)as Dates_FYTD_TY (Returns 1 for all dates in this financial year to date (starting in April)
          if(InYearToDate (Date, today(),-1,4),1,0)as Dates_FYTD_LY,(Returns 1 for all dates in previous financial year to date
      if(InMonthToDate(Date, today(), -1),1,0)All dates last month


      I'm trying to now return a 1 or 0 for:


      Any dates that are the previous year of the last month (in context of this that would be December 2013.


      Thanks in advance