Hello everyone below have a query select * from TR_TRAINING_SESSIONS_M where TRAINING_DATE between '1/1/2019' and Getdate() i want to get data between these date range , but when i execute it return others rows which are not in this date range ?? thanks in advance

i think datatype of this field TRAINING_DATE is varchar thats why you face this issue please try this query select * from TR_TRAINING_SESSIONS_M where cast (TRAINING_DATE as datetime) between '1/1/2019' and Getdate()

ok when field is varchar then you have to cast as datetime

SELECT * FROM [MyDateTable] WHERE StartDate BETWEEN cast ( '02/01/2007' as datetime) AND cast ( '01/04/2008' as datetime) you need to cast . that's it