var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: question/problem using DateAdd function
I am attempting to use the a SQL expression using DateAdd to calculate a future date based on pastdate and X number of months.
The following expressions work great in a form and query (respectfully)
Problem is I would like this value stored in tblMasterEquipment
Is there some unwritten law that says I cannot use this expression as the default value in a table field? (It doesnt seem to work). I am very open to suggestions. thanks in adavance!!!
I have tried this previously and can only vaguely remember something about formatting the dateadd function.
I seem to think to make it work in SQL I had to format the date, something like:
This then forced access to correctly interpret the date in the SQL statement.