Thread: How to filter between two dates in MS Query criteria when the dates are text ("20180903", etc.)
View Single Post
 
Old 09-11-2018, 01:08 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
In source are string values instead of dates?

I'm not sure without testing it out, does MS Query use worksheet or VBA syntax in formulas, so you try either
...>= TEXT([enter start date], "yyyymmdd") AND ... <= TEXT([enter end date], "yyyymmdd")
or
...>= FORMAT([enter start date], "yyyymmdd") AND ... <= FORMAT([enter end date], "yyyymmdd")
Reply With Quote