I'm trying to use the DateAdd function in a Query. I have a field called "Free Trial Start Date" and when that date is entered I want the field "free trial Exp Date" to display automatically with 30 days added to it. I can't get it to work. I enter
DateAdd: ("d",30,[FreeTrialStartDate],Date())and it tells me that I've entered an invalid identifier or typed parentheses follwing the Null constant. Please help.

Thanks!!!!!!

Try this instead:

FreeTrialExpDate: DateAdd("d",30,[FreeTrialStartDate])

HTH
RDH

Thank you so much for writing back so quickly.

I have tried that one as well and it still says that I have either entered an invalid identifier or have parentheses after the null constant. could it have something to do with information in the Data Type field? I'm very new to this!

Thank so much!

I tried this,

=DateAdd("d",30,[FreeTrialStartDate])

and it came up blank... I'm not sure what to do next.

Thanks.

I'm at a loss here ....

Is the name of the field:
FreeTrialStartDate
or is it:
Free Trial Start Date

RDH

I finally figured it out. Thanks!