How many years, months & days passed between to dates

• sam-433147

  Ten Centuries

  Points: 1221

  More actions

  October 1, 2008 at 2:03 pm

  #72134

  How can i calculate

  How many years, months & days passed between to dates

  so result will be (years)(months)(days)?

  for example:

  Dec 31, 2005 -> Jan 1, 2006 -- (0)(0)(1)

  Feb 28, 2006 -> Mar 28, 2006 -- (0)(1)(0)

  Feb 28, 2006 -> Mar 31, 2007 -- (1)(0)(31)

  thanks

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  October 1, 2008 at 2:49 pm

  #879743

  Make use of Datediff function and its input parameters like dd for day, mm for month etc.

  MJ