Datoer problemer

Hej

Jeg har følgende kode, som giver fejl:
strSQL="select * FROM search WHERE email_sent = 'false' and datopublish <= #" & Year(date) & "-" & month(date) & "-" & Day(date) & "# and datopublish > #" & Year(date) & "-" & month(date) & "-" & Day(date) - 14 days & "#"

Jeg ved ikke, hvad man skal skriv i stedet for "14 days".

Resultatet skulle gerne blive:
select * FROM search WHERE email_sent = 'false' and datopublish <= #2003-7-9# and datopublish > #2003-6-23#