AnsweredAssumed Answered

Comparing Dates

Question asked by Atkins on Jan 28, 2013
Latest reply on Jan 28, 2013 by philmodjunk


Comparing Dates



     I'm having a real brain-fart moment.  I'd like to have a calculation that compares two dates and returns the value of "Age" in number of years.  For example

  •           1/1/13 to 1/1/14 would return 1
  •           Anything less than that would return 0
  •           Anything more than one year would return the number of years

     The issue I'm having is that if you only use the Year ( xxx) function then an item from December of last year looks like it's a year old now, even though it's only a month old.  Can someone give me a function that takes into account exactly 365 days when comparing?  I've tried a few different things and haven't had any luck.  I'm sure I'm just missing something small.

     Does this make sense?  Thanks!