Date Function

[domingsun]

Hi all,
I designing a form,
i have a field for date,
i using the formular =Date() to get current date,
but i want a new formular,
example : today is 28 Aug 2013 , but i want the date show the date after 30days, means today is 28 aug 2013 but showing 27 Sep 2013,
what formular can make this?
urgent thanks ^.^

 

[Alansidman]

Use the DateAdd function

http://www.techonthenet.com/access/functions/date/dateadd.php

 

[domingsun]

Hi Alan,
if i use =Dateadd(d,30,now())
this formular can?

 

[missinglinq]

=DateAdd("d",30,Date())

Linq ;0)>