How to enter dates between ? and ? in the criteria section of a database?

		Microsoft Office Forums > Microsoft Excel > Excel
How to enter dates between ? and ? in the criteria section of a database?

FAQ

Thread Tools

Display Modes

07-05-2022, 12:26 AM

Debaser

Windows 7 64bit How to enter dates between ? and ? in the criteria section of a database?

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

Quote:

Originally Posted by Jules90

As I’m entering two dates in one box under Order Date in the Criteria Section, I’m not sure how I should type this?

You need to duplicate the Order Date header in another column and put the >= criterion in one column and the <=criterion in the other.

Alternatively, you can use a formula criterion instead.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to enter 'Page 1' from the footer menu in the right hand section, and not the middle section?	Jules90	Excel	2	08-11-2021 06:44 AM
How to filter between two dates in MS Query criteria when the dates are text ("20180903", etc.)	kingmb	Excel	2	09-11-2018 01:08 AM
Create a unique list of values that match a criteria, sorted in order of another criteria	BradRichardson	Excel	2	01-03-2017 12:25 AM
Why do you need to enter your password twice when connecting to an SQL Server database?	Dedication99	Mail Merge	0	08-05-2016 02:18 AM
Is there a way to detect duplicate dates as I enter them?	Karin	Excel	1	03-04-2011 12:56 PM