Hi

I have writen what i thought was a simple query to filter down service records.

I have a Calculated field
DueDate:[LastServiceDate]+([ServiceInterval]*7)
this has the criteria
Between[Week Commencing Monday dd/mm/yy] And Date("d",+6,[Week Commencing Monday dd/mm/yy])

I was happy to start with as it seemed to work, but the by accident i typed in the year as 2003. It then displayed all my records?.

Has anyone had the same sort of trouble?.
I would be happy to email it over if anyone would be interested in having a look.

Best Regards
Alex
email@on-2.co.uk

[This message has been edited by alxj (edited 09-14-2001).]

What is [Week Commencing Monday dd/mm/yy] ?
Surely the field/dialogue box should just be enter start date, have you defined the parameters?

You're going to have to have the users enter the parameter dates in US format or convert them yourself.

I'm assuming that - Date("d",+6,[Week Commencing Monday dd/mm/yy] - is a typo and "Date" should really be "DateAdd".