This content has been marked as final. Show 3 replies
It would be nice to prefix 01 and then convert this to date.
Above code return the output dd/mm/yyyy, you might need to cast it to date.
If helps pls mark
Edited by: Srini VEERAVALLI on Feb 11, 2013 6:33 AM
Thank for reply..
I have to do in RPD or answers.
Can you please elaborate your explanation .
Code works in both, Answers or RPD. I would suggest to do in Answers once you are good with output then put it in rpd.
Pull column ROD in Criteria tab->fx use the given code and make sure you use complete column at ROD which is TableName.columnName.
In rpd you have to use the same code and ROD pointing to physical column in the expression.
Let me know for issues.
Edited by: Srini VEERAVALLI on Feb 11, 2013 7:09 AM