4 Replies Latest reply: Nov 21, 2016 1:14 AM by Hemanth Aanichetty RSS

    Getting years as a number, not date

    Steve Zagzebski

      I have the following expression which works fine and converts to '2015'

       

      =Date(AddMonths(Today()-12),'YYYY')

       

      but when I modified it to:

       

      =Date(AddMonths(Today()-12),'YYYY') x 12

       

      I want it to take 2015 x 12 = 507936 instead of 24180.

       

      How do I get it to look at the year as a number for this expression instead of a date?

       

      Zag