I trying to use the following formula to add the date, looking up a valbe from another table
=DateAdd([Frequency]![FreqValue],[Frequency]![FreqInterval],[Last Date Done])
table 1
task
start date
freq
table 2
freq=fornight
freqvalue=d
freqinterval=14
anyone see where i'm going wrong?
=DateAdd([Frequency]![FreqValue],[Frequency]![FreqInterval],[Last Date Done])
table 1
task
start date
freq
table 2
freq=fornight
freqvalue=d
freqinterval=14
anyone see where i'm going wrong?