calculating month

• ritesh-296675

  Say Hey Kid

  Points: 678

  More actions

  March 9, 2006 at 3:39 am

  #189566

  Hi,

  I need to take away [startdate] - [enddate] but I need to get the month and display this in a query in Access.

  Can anyone help me please?

• Michael Lee-169622

  SSCommitted

  Points: 1721

  More actions

  March 10, 2006 at 7:36 am

  #625960

  I think I am a little confused. Do you want to know what the difference between the two dates is in months?

  DATEDIFF(month, [startdate], [enddate]) will give you the difference in months.

  ---

  Shalom!,

  Michael Lee