This content has been marked as final. Show 7 replies
Yeah its know issue, not sure about fix.. if possible go for a work around by replacing 'd' with 0 or by substring etc.1 person found this helpful
Just in case if you come with fix let us know
If helps pls mark
Thank you veeravalli for your quick response.
So is it a obi 18.104.22.168 issue?
I will try to use substring and will keep you posted on further updates.
When I had this issue, I had to use a DATETIME column source rather than DATE, as a workaround.
Datetime as in the database table or in the physical layer in the RPD?
I am not able to use substring/replace in reporitory init blocks. It still defaults to .0d . I am using the variable as default value in dashboard prompt. By any ways can we use substring/replace in dashboard prompt?
Of Course we can do that.
Your substring should not be in init block, it suppose to be where you are referring rep variable.
In your prompt to set default values use sql query something like
SELECT Time."Month" FROM "SA" WHERE Time."Year"=SUBSTRING(VALUEOF("PREVIOUS_MONTH") FROM 1 FOR 4)
If helps pls mark ;)
We too faced the same issue. This issue is fixed in the version 22.214.171.124.7 BP.