sql - 在/不在日期

Question

我的代码是：

 RECSET.Open "select isin.LB_LONG from DB_RGA isin, DB_VALEUR_RGA val" & _
                " where isin.CD_RGA = '" & Code_Isin & "' and isin.IS_RGA=val.IS_RGA and (val.D_COTATION in ('28/08/2020','') or val.D_COTATION > '13/10/2020') and val.D_COTATION not in ('17/10/2020')", cnn_Pefase, adOpenDynamic, adLockBatchOptimistic

我需要选择是28/08/2020ormissing value或 > 13/10/2020but not的日期17/10/2020。

标签： sqlexcelvba