using datediff or alternative

[critical5]

Hi there,

Could someone help with this query? I want to select customers who have viewed a property in the last 14 days.

This is what i tried but not working...it seems to select all customers. Any help would be appreciated.

[Steve Sommers]

Try this:

[Dan_Bracuk]

Different databases have different date functions. You didn't state what you are using.

[Steve Sommers]

The CreateODBCDate method I showed above works with MS-SQL, MySQL and Access -- the big three. I have no idea if it works on Oracle (nor do I care; oops, did I type that out loud?)