What I’ve found is that the link works in Chrome, but if I do the same thing in safari I get an error that says “Error running query: missing values for StartDate, EndDate parameters.” After playing around a bit, I noticed that if I change the date format in the query string to be YYYY-MM-DD it works. So this would be the corrected link.
So your question rang a bell with me. Basically, what I did was I added the parameters as hidden columns to the table visualization with the following:
, StartDate = cast(datepart(yyyy, ‘{{StartDate}}’) as varchar(4)) + ‘-’ + cast(datepart(MM, ‘{{StartDate}}’) as varchar(2)) + ‘-’ + cast(datepart(dd, ‘{{StartDate}}’) as varchar(2))
, EndDate = cast(cast(datepart(yyyy, ‘{{EndDate}}’) as varchar(4)) + ‘-’ + cast(datepart(MM, ‘{{EndDate}}’) as varchar(2)) + ‘-’ + cast(datepart(dd, ‘{{EndDate}}’) as varchar(2))
That was the culprit for stripping out the leading zeros.
And I formatted those with ‘YYYY-MM-DD’ in the table. The issue now is that the URL that is being built for the link includes the full datetime instead of the formatted dates. Any suggestions to get around that?
So I got it to work with a hack… I formatted my dates and concatenated with dummy parameters. That kept the column from getting automatically converted to datetime. I’m hiding these columns so no one can see them. The link get’s built correctly with the extra parameters but they just get ignored by my second dashboard.