[GENERAL] Selecting between dates

[Wim Kerkhoff]

Hi,

I am creating a script that sends out reminders to subscribers to a site who
have not paid.  I can't figure out the math that will add 7 days to a date.

I want something like this:

select * from company where created 
is between (lastpaid + 14 days) and (created + 28 days);

I can't figure out the syntax that will let me add days to a date.  I checked
the archives and the Postgresql doc's, but nothing.

Ideas?

Thanks,

Wim Kerkhoff.