Dates in Stored Procedures

I have a stored procedure that takes date as input.

However when I setup the report in designer the parameters are text

I change that to date, but the preview still does text and when I save and reopen it is back to text.


We’ll look at this and follow up here.

Can you try to edit the parameter syntax in the Routine Query assistant and add a |format=date manually? Ex. {{EndDate=2021-09-30|format=date}}. This should be done automatically of course, however until this is fixed, applying the change manually should do the trick, too.

Hi Chris - strange, this works on our end. Could you get in contact with our support team to sort this out?