Hi all,
i am connecting to sql server 2005 through universe designer.
the dates in sql database are in the following format
'YYYYMMDD' -> datatype is character.
Now In the universe i would like to convert datatype 'character' to 'date' .
How to achieve this?