Date = 31/07/2007 - Need to highlight each 4 days preceding it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a diary type database where I have customers scheduled in for works in
the future. I have to contact each of these customers every four days prior
to the works commencing. I have tried the solution provided to me previously
by Allen Brown but this is not giving me the results I require - only passes
a single date back.

Any Ideas on a way forward

Many thanks in advance

PMK
 
Try,
' To display all the records that there date field smaller then today date +
4 days
' In the criteria of the date field write
< DateAdd("d",4,Date())

'Or, to dispaly all the records that fall between today and today + 4
'In the criteria of the date field write

Between Date() And DateAdd("d",4,Date())
 

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

Filtering by increments of 4 2
Yearly Calendar report with highlighted dates 1
Week commencing date reporting 1
Spreading date range across days in weeks (advanced) 7
SQL to determine Start Date and End Date for consecutive dates 1
Highlighting cells with specified dates 2
Need to convert Julian Day to Gregorian date 8
Sum error when adding 31 days 6

Back
Top