I am trying to add the number of months as referenced in my "profile months" field (in my FERC DATABASE2 table) to the date in my Tender Expiry field of the same table
I have seen the DateAdd function
where
DateAdd(Interval,Number,Field)
This works fine if I put
DateAdd("m",1,],[FERC DATABASE2]![Tender Expiry])
...this adds one month to the tender expiry field.
My problem is that I don't have a fixed number of months that I want to add to the tender expiry field. I want to add the number of months as detailed in the profile months field (which contains numbers 1-12)
So I entererd the following...
DateAdd("m",[FERC DATABASE2]![Profile1Mths],[FERC DATABASE2]![Tender Expiry])
I just get an error in the calcualtion field - any ideas?
Any help would be greatly appreciated!
I have seen the DateAdd function
where
DateAdd(Interval,Number,Field)
This works fine if I put
DateAdd("m",1,],[FERC DATABASE2]![Tender Expiry])
...this adds one month to the tender expiry field.
My problem is that I don't have a fixed number of months that I want to add to the tender expiry field. I want to add the number of months as detailed in the profile months field (which contains numbers 1-12)
So I entererd the following...
DateAdd("m",[FERC DATABASE2]![Profile1Mths],[FERC DATABASE2]![Tender Expiry])
I just get an error in the calcualtion field - any ideas?
Any help would be greatly appreciated!
