Dateadd issue

[punter]

Hi,

This problem has to be easy but I can't make it work. The attached database has a table name BOL information. Inside that table are the two columns I'm having an issue with. I want ETA Date to be 30 days after BOL date. I have been screwing around with the Dateadd function and can't get it to work. I have been putting the following in the default value of ETA date:

Dateadd("d",30,[BOL Date])

The error message I have been getting is The database engine does not recognize either the field 'BOL Date' in a validation expression, or the default value in the table 'BOL information'.

What am I doing wrong? Should I not be putting the formula in the default value? Should I use another way to get this calculation? Your thoughts are most welcome.

Thanks in advance.

Eddie.

 

[boblarson]

You shouldn't store that information anyway. The formula works in the controlsource property just fine. If you need to reproduce it on a report or query, just use the formula again.

 

[punter]

Thank you for your quick reply Bob. I see your point. That makes sense.

Eddie.