Calculate an expired date

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

Hi All,

I am trying to build a query that will allow me to show
any records past there end date.

Each record has a start date and an end date and i need
to display only those that have past the end date or are
5 days before the end date can someone help
 
Something like WHERE EndDate >= DateAdd("d", -5, Date) should do it.

To create this through the GUI, put >= DateAdd("d", -5, Date) in the
Criteria cell under your EndDate cell.
 
Thanks but i couldnt get it to work as it always ends up
in a new coloum and an error:Data Type Mismatch In
Critria Expression ia prity new to this and cant get it
working
 
Back
Top