Jump to content

Age & Projected Date Calculation.


This topic is 5708 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 5708 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.