advancing the date

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

Dave B

Hi, I have tried the statement below but all it does is list the dates as
normal, the only way it seems to work is if i enter Date()+7 which advances
the current by 7, but im interested in advancing a date already entered with
a table.

This is wot ive entered but doesnt work, in response to the reply.
Expr1: [DateIssuedRecieved]+7

Thanks

Dave






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

DueDate: [IssueDate]+7
 
Is DateIssuedReceived a date?

Try...

DateAdd("d", 7, [DateIssuedReceived])

If it is not formatted as a date, then...

DateAdd("d", 7, format([DateIssuedReceived],"short date"))


Rick B



Hi, I have tried the statement below but all it does is list the dates as
normal, the only way it seems to work is if i enter Date()+7 which advances
the current by 7, but im interested in advancing a date already entered with
a table.

This is wot ive entered but doesnt work, in response to the reply.
Expr1: [DateIssuedRecieved]+7

Thanks

Dave






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

DueDate: [IssueDate]+7
 
The DateIssuedReceived is a date, 23/04/04


Dave


Rick B said:
Is DateIssuedReceived a date?

Try...

DateAdd("d", 7, [DateIssuedReceived])

If it is not formatted as a date, then...

DateAdd("d", 7, format([DateIssuedReceived],"short date"))


Rick B



Hi, I have tried the statement below but all it does is list the dates as
normal, the only way it seems to work is if i enter Date()+7 which advances
the current by 7, but im interested in advancing a date already entered with
a table.

This is wot ive entered but doesnt work, in response to the reply.
Expr1: [DateIssuedRecieved]+7

Thanks

Dave






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

DueDate: [IssueDate]+7



Dave B said:
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
Click to expand...
must
have
a reply from u by the XX April 2004'.


Thanks in advance,

Dave
Click to expand...
Click to expand...
 
Back
Top