Counting dates

[jorg32]

Hi,

I want to check in a SQL when a client hasn't payed his bills after more then 30 day's.

e.g. He has to pay on 2005/02/25 and if he hasn't payed after 30 day's (2005/03/27), he has to pay something extra.

What do I have to do so SQL count on this date every time 30 day's?

Thanks for helping me.

J.

 

[johnv20]

declare @TimeSincePaid int,
	@Overdue varchar(10)

select @TimeSincePaid = (select datediff(day, 'Mar 10 2005', getdate()))

if @TimeSincePaid > 30
	begin
	select @Overdue = 'YES'
	end
else
	begin
	select @Overdue = 'NO'
	end