if rsDisplayAll("signeddate") <> "" then  ' if signed date is available
   if isnull(rsDisplayAll("InstallationDate")) and (datediff("d",rsdisplayAll("signeddate"),date) > 3 ) then   
    Response.write " <font color=#0033ff> Attention! :- 3 days since signed date. Please enter an installation date.   </font><br>"
    alert=1
   end if  
end if

if rsDisplayAll("signeddate") <> "" then  ' if signed date is available
   if isnull(rsDisplayAll("InstallComplete")) and (datediff("d",rsdisplayAll("signeddate"),date) > 15 ) then   
    Response.write "<br>   <font color=red> Warning! :- Installation incomplete 15 days after signed date. </font>"
    alert=1
   end if  
end if

create procedure sp_Test1  @AnyParameter DataType, @ReturnMsg  Varchar(100) OUTPUT
AS
BEGIN
	Declare @i int
	
	Set @i = Select  datediff(.....) from .... where signeddate is not null and signeddate <> ""
	if  @i > 3 and @i < 16 
	Begin
		Set @ReturnMsg = 'Attention! :- 3 days since signed date. Please enter an installation date.' 
	End
	if  @i > 15
	Begin
		Set @ReturnMsg = 'Warning! :- Installation incomplete 15 days after signed date.' 
	End
End

quote:

---

Originally posted by jsmith8858

This is not a good use of stored procedures ... it has nothing to do with processing data in the database, it has to do with evaluating a condition and deciding which HTML to render.

---