Hi, trying to work out how to extract data, using a report, when one date (27/05/09) is more than 5 days compared to another (21/05/09). I have tried using DateDiff without success - just get "data type mismatch in criteria expression" when i use the following
DateDiff("d",5,"Date created","Date Amended by PDA")

Anyone help?

if DateDiff("d","Date created","Date Amended by PDA")> 5 then

do something