Overdue Date Query

[Steve WWU]

I have always used <Date() or <-Date() in queries to find records that are overdue before. I am now getting dates returned for 01/03/2011 which obviosuly arent overdue. Any ideas - I have tried indexing the date filed in the table and removing the type and even checking all current date settings on the PC to no avail - anyone?

 

[DCrake]

What regoinal settings have you got UK or US?

 

[Steve WWU]

Hi David UK settings

 

[DCrake]

Try using DateDiff()

OverdueateDiff("d",Date1,Date())

Condition >0

 

[accessfever]

Did you check the field's property -> format in the query if it is same as the PC's date format?

 

[Steve WWU]

Thanks David

I will give that a whirl. Looks good to me.
Thanks for all your help

Steve

 

[Steve WWU]

You're not going to believe this guys (or maybe you are) it was a simple problem in the end - the table I was querying had the field set as text and not date format - relly elementary mistake. Sorry to have wated anyones time but thanks for all the advice.

Regards

Steve G