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
 
Back
Top