advancing a date

  • Thread starter Thread starter Dave B
  • Start date Start date
D

Dave B

Hi,

I am currently trying to advance the date within a query, the query at the
moment displays all letters sent that are more than 7days old. This is done
by using <=Date()-7 in the criteria box of the date the letter was issued.
The date im trying to get displayed is 7 days from when the letter was
issued. This is so i can then use it in a report that displays 'we must have
a reply from u by the XX April 2004'.


Thanks in advance,

Dave
 
In the "Field" section of your query type something similar to this:

DueDate: [IssueDate]+7
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating an update query that uses multiple parameters 2
Error Message related to 2009 dates 1
advancing the date 2
Asset Management - PC Birth Date 11
Creating a "Greater Than Date" criterion 2
Overdue dates 7 days old or older? 2
Which is the best MBOX Converter Tool different formats conversion? 4
Excel Help with dates 2

Back
Top