Set Default Date in a table.
Posted on 2006-11-24
I am making a Database where I want to set the default date in the "DueDateS1" field to be 30 days from the "Date" field.
"Date" = Entered by data entry in table or Form
"DueDateS1" = To automatically calculate off of the "Date" entered.
I tried to use the DateAdd("d", +30, <<date>>) function and I am not sure what goes in the <<date>>. I've tried using both "Date" and "DueDateS1"
I am pretty new to writing this type of code so any help would greatly appreciated.