I have some dynamic DATE variables created which fetches date values from a table. In the table the data type for that field is INTEGER.
But on starting the server all date variables are initialized with .0d appended in the end. LIke 2012.0d etc.
Kindly provide some pointers!
Edited by: 959902 on Oct 30, 2012 8:26 AM
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 ;)