Age & Projected Date Calculation.

[adamkarwowski]

I cant seem to get this to work.

i have 3 seperate calculations. one being

current date - date of birth = age

and

date field + 2 weeks = projected date field

and

date field + 45 days = projected date field.

i know it probably simple as hell but cant figure out the parameters.

Thanks in adavnce.

[bdam]

What parameters are you having difficulties with?

Use "get ( currentdate )" and add or subtract the number of days (not weeks, or months) you want from there.

[Lee Smith]

There are several age calculation posted around the Forum, if you do a search for the keywords, you should come up with what you want.

Check out these two Threads first:

First

Second

BTW, do you want the results to be just years? (i.e. 6.4)

Years, months and days (i.e. 6 years, 3 months, 22 days)

The projected date = two weeks is 14

date field + 14

The projected date = 45 days

date field + 45

It seems that you might want some flexibility in this calculation. You can create a Number field call Num_Days, and use that instead.

date field + Num_Days ( In the Num_Days field you will have put 14or 45)

[adamkarwowski]

thank you bdam and lee.

you guys definetly pointed me in the right direction which i needed.

last thing i wanted you guys to do was walk me thru it step by step.

Ugo is a great teacher LOL.

With your help of course, i was able to make the date calc buy doing this

Year(Get(CurrentDate)) - Year ( Date of Birth: )

and the projected date by doing this

Phase 1 Date + 15

Phase 2 Date + 45

respectivly. of course, setting the result as date.

Edited February 13, 2007 by Guest