Date operations in mysql

Question

I have the following queries in mysql . The valid data exists in the database for both queries but The first query is working but the second is not . do we use any functions to operate on dates ?

The difference between these queries are just the last part " AND Q_DATE < '2/28/2018' "

WORKING

SELECT EFFECTIVE_START_MONTH, EFFECTIVE_END_MONTH, C_NAME, S_ID, SAN, STATE, D_AMOUNT, FUND_TYPE, STATUS, C_ID, D_TYPE, C_GAP, Q_DATE, COMMENT, F_APPLIED_ORDER_NUM, F_APPLIED_ORDER_DT, DISBURSEMENT_RECOVERY_DT FROM VIEW_PAYMENT_D_SUM WHERE S_ID IN (2, 3, 5, 1) AND Q_DATE > '1/23/2018'

NOT WORKING

SELECT EFFECTIVE_START_MONTH, EFFECTIVE_END_MONTH, C_NAME, S_ID, SAN, STATE, D_AMOUNT, FUND_TYPE, STATUS, C_ID, D_TYPE, C_GAP, Q_DATE, COMMENT, F_APPLIED_ORDER_NUM, F_APPLIED_ORDER_DT, DISBURSEMENT_RECOVERY_DT FROM VIEW_PAYMENT_D_SUM WHERE S_ID IN (2, 3, 5, 1) AND Q_DATE > '1/23/2018' AND Q_DATE < '2/28/2018'

aloks0189 · Accepted Answer

Hi @Ramanan try using between operator to deal with range of date, as mention below: 
 
WHERE .............. AND (date_field BETWEEN '2010-01-30' AND '2010-09-29') 
 
Make sure that, min date will be placed first followed by Max date as shown above. 
 
Hope this will help.