Stored Procedure error

[rmcgrath]

Ok, no everything I have tried continues to produce the following error:

Here is the stored procedure I am trying to execute:

What am I doing wrong?  I don't understand the "datetime" error?

[Elena_Kalina · Accepted solution]

Hi @rmcgrath 

This typically occurs when:

• A date value is outside SQL Server's valid range (January 1, 1753 to December 31, 9999)

• There's a type mismatch in date handling

• The stored procedure receives malformed date parameters

Check:

-the date parameters. Try this modified version:

EXEC dbo.spGetDailyLivPct 
  @PDStrDate = '20240101',  -- ISO format (YYYYMMDD)
  @PDEndDate = '20250611'

-  for NULL Dates in Source Data

-  for Invalid Dates in Results. The error might come from the result set. Try limiting columns

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.