I'm writing a SQL query to get rows between a date range format: mm/dd/yyyy I used the between operator but the result shows out of the range dates The expected result : dates of year 2020 only The actual result is: Answer I assume that you use SQL Server. Maybe you think that % is a wildcard char in this

SQL between date range returning a wrong result

I’m writing a SQL query to get rows between a date range format: mm/dd/yyyy

I used the between operator but the result shows out of the range dates

Select Internship_StartDate1
From [Media_BPM].[dbo].[BP_UGME]
Where TrainingType = 'Medical Internship Training'
  and Internship_StartDate1 Between '01/%/2020%'  AND '06/%/2020%'
Order By Internship_StartDate1 desc

​x
 
Select Internship_StartDate1From [Media_BPM].[dbo].[BP_UGME]Where TrainingType = 'Medical Internship Training'  and Internship_StartDate1 Between '01/%/2020%'  AND '06/%/2020%'Order By Internship_StartDate1 desc​

The expected result : dates of year 2020 only

The actual result is:

Internship_StartDate1
05/16/2018
05/06/2018
05/05/2019
05/05/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/02/2019
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2020
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2019
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2018
05/01/2017
04/30/2018
04/29/2018
04/18/2018
04/14/2017
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2020
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2019
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2018
04/01/2017
04/01/2017
04/01/2017
04/01/2017
03/19/2019
03/18/2018
03/04/2018
03/03/2019
03/03/2019
03/03/2019
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2020
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2019
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2018
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
03/01/2017
02/05/2017
02/03/2019
02/03/2019
02/03/2019
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2020
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2019
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2018
02/01/2017
02/01/2017
02/01/2017
02/01/2017
02/01/2017
02/01/2017
02/01/2017
02/01/2017
02/01/2017
02/01/2017
02/01/2017
02/01/2017
02/01/2017
01/20/2019
01/19/2019
01/19/2019
01/13/2019
01/12/2019
01/12/2019
01/12/2019
01/10/2019
01/10/2019
01/10/2018
01/09/2019
01/09/2019
01/09/2017
01/08/2018
01/02/2019
01/02/2019
01/02/2019
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2020
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2018
01/01/2017
01/01/2017
01/01/2017
01/01/2017
01/01/2009

 
Internship_StartDate105/16/201805/06/201805/05/201905/05/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/02/201905/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/202005/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201905/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201805/01/201704/30/201804/29/201804/18/201804/14/201704/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/202004/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201904/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201804/01/201704/01/201704/01/201704/01/201703/19/201903/18/201803/04/201803/03/201903/03/201903/03/201903/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/202003/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201903/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201803/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201703/01/201702/05/201702/03/201902/03/201902/03/201902/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/202002/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201902/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201802/01/201702/01/201702/01/201702/01/201702/01/201702/01/201702/01/201702/01/201702/01/201702/01/201702/01/201702/01/201702/01/201701/20/201901/19/201901/19/201901/13/201901/12/201901/12/201901/12/201901/10/201901/10/201901/10/201801/09/201901/09/201901/09/201701/08/201801/02/201901/02/201901/02/201901/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/202001/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201801/01/201701/01/201701/01/201701/01/201701/01/2009​

Answer

I assume that you use SQL Server.
Maybe you think that % is a wildcard char in this condition denoting any char, but this is not the case.
You can use % with the operator LIKE but not with BETWEEN.
Use the function FORMAT():

Select Internship_StartDate1 
from [Media_BPM].[dbo].[BP_UGME] 
where TrainingType = 'Medical Internship Training' 
AND FORMAT(Internship_StartDate1, 'yyyyMM') Between '202001' AND '202006' 
Order By Internship_StartDate1 desc

 
Select Internship_StartDate1 from [Media_BPM].[dbo].[BP_UGME] where TrainingType = 'Medical Internship Training' AND FORMAT(Internship_StartDate1, 'yyyyMM') Between '202001' AND '202006' Order By Internship_StartDate1 desc​

Advertisement

Answer