Adding a number to a date [Can date cope]

[Elfman]

Here's what I currently have:

- A table with a number of fields about a course
- A course commence date
- A number of days the course will take field
- No course end date

Is there a way to easy add one field to the other to:
Give end date i.e. do I need to write the code to validate all dates which bring the date over a month e.g. start date 29/sep/2007 and number of days 5.

Does date have the functionality already?

Thanks in advance

-Elfman

 

[neileg]

I think a look at the DateAdd() function would be the right place to start.

 

[Elfman]

Ah that's perfect fair play

-Elfman