ritesh-296675
SSChasing Mays
Points: 618
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
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.
Michael Lee
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply