Выборка уникальных значений за определенное время SQL

SELECT DISTINCT t1.*
FROM source t1
LEFT JOIN source t2 ON t1.code = t2.code
                   AND t1.date <= t2.date + INTERVAL 2 DAY
WHERE t1.date = CURRENT_DATE
  AND t2.code IS NULL

Можно этот запрос адаптировать для access ?

SELECT DISTINCT t1.*
FROM source t1
LEFT JOIN source t2 ON t1.code = t2.code
                   AND t1.[date] <= DateAdd("d", 2, t2.[date])
WHERE t1.[date] = Date()
  AND t2.code IS NULL