Not Been Visited in over two years

[angie]

Hi I have the following fields in a query


CustomerID , Service Call Date and Bill To

I need to create a query that will only show the customers that have not had a service call date provided in over two years.

Thank You
Angie

[orange]

See the Datediff() function

[pbaldy]

You may need this to get the last visit for each customer:

http://www.baldyweb.com/LastValue.htm

[angie]

You may need this to get the last visit for each customer:

http://www.baldyweb.com/LastValue.htm

Hi I have the following in my query

datediff("d",[service call date], date ())
Creteria = >360

This works but I need it to just show the records that have not had any service date after the >360

[orange]

Angie,
You said earlier

have not had a service call date provided in over two years.

If(datediff("d",[service call date], date ()))>= 730 then...

[angie]

This didn't work for me

[ItsMe]

If you are using in a query, perhaps you can use Orange's example in the criteria and not include it within an If, Then, Else.

datediff("d",[service call date], date ()))>= 730