Date plus 30 days

  • Thread starter Thread starter TToy
  • Start date Start date
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?
 
Just add +4 to your original date to create a newdate field
SELECT [UPDATE_DT]+4 AS NEWDATE
 
If your date will run into the next month, the more correct code is the DateAdd function

=DateAdd("y", +30, [IssueDate])
 
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])
 
Look up the DateAdd function.

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