Query Criteria Showing Wrong Results?

[alxj]

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).]

 

[Rich]

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