Increasing a date entered

[wildexodus]

A user inputs an order date into the system which will go into a table. I also have another field in the table called 'DueDate'. I need to put in the default value in the field properties a string to take the date from the first date field and add 35 days (or 5 weeks) to it. How do i do this?

 

[KevinM]

First you don't store it in the table.

Create a query and add an expression using the DateAdd function.

Examples on how to use this function are in the Help files.