DateAdd function help

[afelya]

Using CR 8.5

With a help from this forum using below code has helped me to be able to add a starting date to a duration of time such as 1 year, 3 year or 5 year periods at a time to show a monthly value in cells that shows each month of the year.

dateAdd("yyyy", ({BID_SUBJ.DURATION}), {BID_SUBJ.AWARD_EXP_DATE} ))

Now only issue i have is that in the database some duration values are entered such as 0.25 (3 months) and 0.50 (6 months) I am having hard time trying to show data for this kind of values. My formula right now looks at these values as 0's and shows values for that month only, i cant get it to show (if duretion 3 months) for other respective months. ANy help will be appriciated. ALso i have tryed to use month instead of year on the date add and that was only adding months not years that way, so i am not sure how to be able to point out both months and years so i get correct data placed into the month cells...

 

[IdoMillet]

Try using months as the interval type and
12* {BID_SUBJ.DURATION}
as the duration you want to add.

Cheers,
- Ido

ixm7@psu.edu

 

[afelya]

Worked great, thanks...