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

      Stu