Localboy- right on about the date Thanks!! My mind seems to be blurry lately LOL

I did this like you suggested and it works wonders:)

select...
from...
where
dateColumn between DATEADD(dd,30,getdate()) and DATEADD(dd,37,getdate())
...

All I have a problem now is with UPDATE

I modifed this code trying to use joins - doesnt work...any ideas?

UPDATE LiveTableA
SET Status = '1st Notice'
where exists
(
select
a.ID,
a.Status,
----
-----
a.ExpDate as ExpDate,
Table1.name as User,
------
-----
----
Table2.city as Address,

 
from
LiveTableA a
left outer join ..Table1..on
left outer join ..Table2..on

where
 ExpDate between DATEADD(dd,30,getdate()) and DATEADD(dd,37,getdate())
-------
and Table1.codeColumn in ( 'ABC', 'XYZ')
)

THANKS IN ADVANCE!