Date range in months from month and year fields

[Guest]

In our database we track consultants work dates in four seperate fields,
starting month, starting year, ending month, ending year.
Is there anyway to calculate the range of months they have worked with this
set up?

So if someone started March 2004 and ended July 2007 is there a formula to
calculate the 40 months they worked?

 

[Guest]

DateDiff("m",[starting month] & "/" & "01" & "/" & [starting year],[ending
month] & "/" & "01" & "/" & [ending year])

 

[Guest]

Replace the "01" with a day field if you have it.. or you can merge it to
"/01/"

DateDiff("m",[starting month] & "/" & "01" & "/" & [starting year],[ending
month] & "/" & "01" & "/" & [ending year])

In our database we track consultants work dates in four seperate fields,
starting month, starting year, ending month, ending year.
Is there anyway to calculate the range of months they have worked with this
set up?

So if someone started March 2004 and ended July 2007 is there a formula to
calculate the 40 months they worked?

 

[Douglas J. Steele]

If you're actually storing the text for the month (as opposed to a month
number), try:

DateDiff("m", CDate("1 " & StartMonth & " " & StartYear), CDate("1 " &
EndMonth & " " & EndYear))