Stored Procedure: Date calculations using Datediff

• sdugan

  SSC Enthusiast

  Points: 187

  More actions

  March 4, 2002 at 9:27 am

  #78264

  Please excuse my igonorance as I am new to SQL. My question is this: there is a stored procedure that claculates the remaining payments in a lease using the datediff function. datediff(month,@as_of_date, #lease_scheds.end_date) remaining term

  Unfortunately, it returns negative values that we would like to be = to 0. It seems like it should be easy if I only knew more about stored procedures!! How would I acomplish this?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 4, 2002 at 9:38 am

  #424843

  Try this,

  CASE

  WHEN datediff(month,@as_of_date, #lease_scheds.end_date) < 0 THEN 0 ELSE datediff(month,@as_of_date, #lease_scheds.end_date)

  END

  By using case I tell the value to be 0 when less than 0 otherwise print the value.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)