calculating month

• ritesh-296675

  Say Hey Kid

  Points: 678

  More actions

  March 9, 2006 at 3:36 am

  #365461

  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?

• shaun alsobrook

  SSC Enthusiast

  Points: 159

  More actions

  March 9, 2006 at 10:27 am

  #625755

  try this for accees

   DateDiff("m",[Date1],[Date2])

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  March 9, 2006 at 11:29 am

  #625773

  All,

  The poster continued this in another thread instead of keeping it all in one thread.

  The continuation is here:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=264565

  -SQLBill