asked on
Default Date Parameter "Error During Processing"
I'm having a problem with a DateAdd function in SQL Server Reporting Services as default value for a parameter. I've entered the expression "=DateAdd("dd",-60,Today()
Any thoughts?
Any thoughts?
DB Reporting ToolsSSRSMicrosoft SQL Server
Last Comment
itsupport1199
use getDate() instead of Today()
ASKER
It doesn't recognize getDate. I get the squiggly lines underneath it.
Be sure to include the open and close parentheses. GETDATE()
ASKER
I did. Still no luck.
ASKER
This is exactly how it appears in the default value box: =DateAdd("dd",-60, getDate())
Drop the = and see if that doesn't help. ;-)
ASKER
No luck there, either. When I drop "=" the whole expression gets squigglied in the expression builder and I get the error "The definition of the report '/Member Activities by Chapter' is invalid. The property 'DefaultValue' or report parameter 'ActivityFrom' doesn't have the expected type."
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Changing "dd" to "d" worked like a charm.