[Ammukutti]

Hi friends,

It is the situation, there are two dates in short date format(month/date/year). I need the difference between the 2 years in the same format. What i tried is i assigned two dates in 2 variables and did - operation. but it resulted in the difference between 2 month values.

Even i have another doubt too. If i hav a date in this format month/date/year(short date) how can i separate the values of day,month,year.

Pls help.
Thanks in advance.

This post has been edited by Ammukutti: 24 January 2010 - 06:06 AM

[raziel_]

hello
use this function:
Function DateDiff(Interval As String, Date1, Date2, [FirstDayOfWeek As VbDayOfWeek = vbSunday], [FirstWeekOfYear As VbFirstWeekOfYear = vbFirstJan1])
Member of VBA.DateTime
Returns the number of time intervals between two specified dates