garden_rael
Board Regular
- Joined
- Apr 1, 2008
- Messages
- 100
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
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