Calculate an expired 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
 
D

Douglas J. Steele

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.
 
R

Robert

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
 
Top