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'




      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?