calc totals between two dates

[summergirl]

Ooh, this is a stumper. I hope someone can help!

Here are the fields we're dealing with:

LastAssessDate = calculated date

CurrentDate = calculated, using Status(CurrentDate), not Today function

MayHrs = number entered in a related file (represents the month of May)

JunHrs

JulHrs, etc. for entire calendar year

How do I make a calculation that figures out the sum of monthly hours between the LastAssessDate and Current Date?

Example:

LastAssessdate = Feb 1,2004

CurrentDate = March 30, 2004

JanHrs = 10

FebHrs = 24

MarHrs = 6

The answer I'm looking for is 30. I just don't know how to get there with a calculation. I had the start of a field definition, but it was 10 miles long and didn't produce the correct result. Should I be trying to create a single massive calculation?

This is one of those logic problems that makes my hair gray(er)! Any assistance is welcome.

Thanks,

Mary Z

Version: v5.x

Platform: Windows XP