I have a dashboard which uses a couple of date parameters.
The dashboard works fine as long as you type the dates in. However, if you use the date picker and select the dates that way, the parameters no longer work.
Example if I type in 02/01/2022 for the start date and 03/01/2022 for the end date I end up with numerous records.
But if I use the date picker, I get no results.
Anyone ever have anything like this happen and know of any fix (besides just typing the dates every time; that’s what we are currently doing but I would like to not have to do that)
So as I was looking at the parameters, I noticed the third one which is a decimal had no default set. I changed this to have a default of 0. It works now.
Not that this makes any sense but, that’s how I fixed it.