, ,

Hello Everyone,

In my last Blog-Post I used DateAdd function to manage the DateTime paramater in SSRS. While processing the report against a Stored Procedure, I encountered with the following Error:

The datepart minute is not supported by date function dateadd for data type date.

When I looked back into my Stored Procedure, I figured out that the Input Parameter being used were of data type Date.

This was the reason of the error above, as the Date data type runs only till day level. Nothing smaller than that like hour or minutes. But the DateTime data type runs at all the level below.

After I changed my Input parameters from Date data type to DateTime data type, the error was gone!!!


Hope that was Helpful.

Thanks !!!