substract two date

[BIJOY DAS]

I have a date field start_date.i want to substract that date from current date(machine date)and want to get the result as month

[Guido Geurs]

Add this function in a Module in VBA:

Function MonthDiff(MYdate As Variant) As Variant
    MonthDiff = Str((DateDiff("m", Now, MYdate)))
End Function

Use the function (see Attachment)
[imgnothumb]http://bytes.com/attachments/attachment/6111d1329561587/screencap-1.jpg[/imgnothumb]

[NeoPa]

I believe the question is SQL Server (T-SQL) related Guido ;-)

[mohit2k8]

You can use given below function in sql server..
DATEDIFF(MM,sta rt_date,getdate ())