date calculation

[jwermis]

I am trying to create a prorated amount calculation based on a birth month and the month of an exam.

Example: Birthday is 7/6/03 and the exam is 2/6/03. A difference of 5 months. That number is then multiplied by $14.58. I can't seem to get a calculation that will get the difference between the two dates and make it positive integer to multiple by the $14.58. Any suggestions?

Thanks,

Josef

[Vaughan]

I hope you have the birthday and exam dates in real date fields, otherwise none of these calcs will work...

Month(Exam) - Month(Birthday)

but you also need to take the year into account, so it needs to be:

((Year(Exam) - Year(Birthday)) * 12) + Month(Exam) - Month(Birthday)

[andygaunt]

Hi,

try;

Abs(Month(Date1) - Month(Date2)) * 14.58

HTH

[jwermis]

Worked great. Thank you for your help on it. This will save us a lot of manual time.

Josef

[vierdewereld]

Been searching the whole forum but can't seem to find the right answer, so here goes another simple question:

How can I calculate the amount of days before the birth date?

With this formula I get in trouble when Status(CurrentDate) gets past the birth date.

Case(

Day(Status(CurrentDate)) = 31 and Day(birth date) < "30", "1",

Min(

Day(Status(CurrentDate)), 30)) - Min(Day(birth date), 30) + ((Month(Status(CurrentDate)) +

Case(

Day(Status(CurrentDate)) = 31 and Day(birth date) < "30", "1") - Month(birth date)) * 30)

Any idea?