Access 格式化日期函式

SELECT TEST.名字,
       TEST.出生日期,
       Year(Date()) & Format(TEST.出生日期,"/MM/DD") as 今年生日
FROM TEST

Recordset.Filter =
"今年生日 >= '" & Format(Date(),"YYYY/MM/DD") &
"' AND 今年生日 <= '"& Format(Date()+7,"YYYY/MM/DD") & "'"

SELECT TEST.名字,   TEST.出生日期  FROM TEST 
WHERE ( Year(Date()) & Format(TEST.出生日期,"/MM/DD"))
          >= Format(Date(),"YYYY/MM/DD")
  and ( Year(Date()) & Format(TEST.出生日期,"/MM/DD"))
        <= Format(Date()+7,"YYYY/MM/DD");