Calculating months and days in a date range

• levv

  Old Hand

  Points: 392

  More actions

  August 17, 2007 at 11:24 am

  #174296

  What would be the best approach to calculate and display the number of months and days in a given date range? I.e. 01/01/2007 to 02/02/2007 should display 1 months 1 day. Thanks in advance!

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  August 17, 2007 at 12:52 pm

  #727739

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78730

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62729

   

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• levv

  Old Hand

  Points: 392

  More actions

  August 17, 2007 at 2:30 pm

  #727754

  Thanks Peter, that's exactly what i need.