Subject Using Field Named DATE in Where clause From Craig <craig.s@silicon-online.co.za> Date Wed, 14 Feb 2024 04:27:18 -0500 Newsgroups dbase.getting-started I have a database for our orders where each order has the sales person name entered in as to show whose customer it is. using the Where clause I can sort the orders so that only a specific sales person orders show up. However I am trying to use the Where clause to only give out the orders from a specified numbers of days ago. The field name that I am working with is when the order was entered and is labeled as DATE. This seems to be giving issues also I can't seem to get the where function to filter using any of the date fields that I have in the table. I am not sure if I am setting up the clause wrong or how to filter using dates in the where clause.