How to filter between two dates in MS Query criteria when the dates are text ("20180903", etc.)

		Microsoft Office Forums > Microsoft Excel > Excel
How to filter between two dates in MS Query criteria when the dates are text ("20180903", etc.)

FAQ

Thread Tools

Display Modes

09-07-2018, 11:59 PM

Pecoflyer

Windows 7 64bit How to filter between two dates in MS Query criteria when the dates are text ("20180903", etc.)

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Hi and welcome
any chance of changing the fields to real dates ( data - text to columns - Delimited - Next - Next - Check " Date" - Select YMD from dropdown - Finish) ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
X axis graph all dates when date column contains specific dates..possible ?	DBenz	Excel	2	03-28-2018 04:59 AM
The "body of text" for all odd-numbered pages are all "vertically-centered-aligned".	keepcalmandreadabook	Word	5	03-27-2017 04:08 PM
Google "=Filter()" function excel equivalent.	Sadodare	Excel	0	08-01-2016 11:15 AM
Formula for filter "Incomplete Tasks for User..."	patrickd123	Project	1	04-07-2015 08:15 AM
Filter 2 columns between 2 dates	s_samira_21	Excel	2	02-08-2015 10:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:54 AM.