formula help

[IDTJoe]

i have a nice database which is working well apart from one part

i have 2 date fields, you enter in any date in the first and i need a formaula which will generate a date 6 weeks in the future

can anybody help or suggest what to do?

 

[stephen81]

DateAdd("ww",6,[First_Date_Field])

Check out the help file for other date intervals you can use i.e yyyy = year, q = quarter etc.