Categories
Parameter saying that the query results are "Integer" when they should be date, text etc.?
I am trying to create a column that is the exact same as the current date parameter, but I want it to be the day prior to current date.
Like the above example I would like for it to be the day previous.
I've tried doing a parameter that's current date - 1, however it says the result of this is an integer rather than a date. How can this be fixed?
Best Answer
-
Create a calculated column first and then use it.
0
Answers
-
Perhaps I am not clear about your question. But you can do the following:
0 -
So what I'd like to do is take that previous date calculation you have there and put it into a parameter, similar to the out of the box parameter 'Current Date'. The reason for this is we'd like to have a little box that shows what date they can expect their data to be updated through. For us, the daily refresh runs overnight so the data is current through yesterday.
These are the out of the box parameters. We'd like to create our own parameter 'previous date'. However, when trying to validate the parameter, it disputes the data type created. Any ideas on how we can fix this? @fbarazan-Oracle
0 -
Would this work for you?
0 -
@fbarazan-Oracle If I choose 'Column' under available values I get a list of values pertaining to the subject areas in the report.
Also you have to have a value under initial value. Did your parameter save like that??
0 -
That worked for me thank you
1