Date plus 30 days

T

TToy

I am trying to write a query that will produce an new date
for me. I have a database that has 'permit issued
field'. This is a date field. The permits expire 30 days
after they are issued. Is there a formula that will yield
an expiration date?
 
B

Barbara Grace

Just add +4 to your original date to create a newdate field
SELECT [UPDATE_DT]+4 AS NEWDATE
 
B

Barbara Grace

If your date will run into the next month, the more correct code is the DateAdd function

=DateAdd("y", +30, [IssueDate])
 
F

fredg

I am trying to write a query that will produce an new date
for me. I have a database that has 'permit issued
field'. This is a date field. The permits expire 30 days
after they are issued. Is there a formula that will yield
an expiration date?
Click to expand...

ExpireDate:DateAdd("d",30,[IssueDate])
 
J

John Spencer (MVP)

Look up the DateAdd function.

Field: ExpiresOn: DateAdd("d",30,[Permit Issued])
 
Top