6 Replies Latest reply on May 5, 2016 11:19 AM by youngji seo

    How do I get the previous year if the day is different?

    youngji seo

      Hi I used this formula: DATEADD('year',-1,[Date Selector])

       

      but it is giving me exactly 1 year prior for ex 9/30/2016 --> 9/30/2015 which doesn't exist in my data set since it is business month end only. How do I change it so that it looks to the prior year and month and does not take into account the day? If the prior year is 9/29/2015 for ex.

       

      Thank you!