Jeff Hi,

No matter what I try, I cannot get your code snippet to work, is there any possibilty you could expand it to show its used with code and using northwind.sdf. If I take out the --Today shown in Green in your code and having assumed it may be a comment it tells me the function Year is not recognised by the Compact Edition. When left in it gives an error parsing the query at Line 1 position 166 error = ,

But I cannot get rid of the error.