Sum days to a calculated Date

[garden_rael]

I had a problem summing a number of days to a calculated date

I tried several ways but if i generate a date from another date already included in the table and then i try to sum a number of days to the generated date, it shows error

for example

DATE1: included in the table, example 07/01/2008

DATE2: [DATE1]+2 (this works)

now if i try to sum a number of days to this date it shows error

DATE3: [DATE2]+1


Consider that i must do it this way, there are several conditions involved and i can't put the full formula together, I NEED THE 3 DATES AND IF I PUT THE WHOLE FORMULA TOGETHER IT WOULD BE COMPLETELY HUGE

Any idea why is this error showing?


Thank you

 

[Joe Schmeaux]

Your solution should work based on what you have posted. What error are you getting?

 

[garden_rael]

all solved by DateAdd

Thank you so much!

 

[Norie]

Could you please post the solution here and in all the other forums you crossposted in?

 

[garden_rael]

Ok

DATE1 is included in the formula

DATE2 is calculated with certain conditions (this works and it's easy)

DATE3 would

DATE3:IIF(CONDITIONS,DATEADD("D",3,[DATE2]),DATE2)

my formula is way bigger than that, but that's the core of the formula