Hi ,

I have a date time field in DB table and in FM i have changed the format from datetime to date using to_char function and after republishing the package if i drag the date field in report its working fine (ie) its showing only date but in dashboard if i drag the same date field then its showing the values in timestamp that is its taking default data type given in db. But users don't want to change the format in dashboard manually when they drag date field it should display date by default.

Please let me know whether dashboard will take only default datatype given in db table or any work around is there to achieve this.

Thanks in advance..

------------------------------
Pavithra N
------------------------------

#CognosAnalyticswithWatson

Hi Pavithra,
A couple of other ways of doing this. 
Use the cast function :   cast ( [date_item] as date )
or you can specify a format for the item in FM.
I hope this helps

------------------------------
Kind regards,
HENK CAZEMIER
------------------------------