on 09-10-2014 6:11 AM
Hi
we have data in our reporting database (sybase iq 15.4) as the datetime type and the data is storing as below
2014-09-09 22:31:42.124, my objective is to create object based on this column and use it in Reports, which should be I18N standard, and drill up to minute,hour,day,week,month,year. ( i have different columns in the database for these hierarchy).
Now when i create an object in universe using the column - first of all i don't have datetime type to define ( i am using BO XI 3.1 SP5), so set it to date type.
now when i drag this object in webIntelligence report, by default it is showing as 9/9/2014 : There is no time information here.
but when format the cell to display hours/minutes/seconds, it is showing properly
Now the Question is :if the change the viewing locale, the format is not changing accordingly,
could you please let us know how best we can solve this issue?
and also if i drill up to day or hour, it is giving #format error.
Please let me know your thoughts to solve this issue
Regards,
krishna Rao
Hi,
Use Format Date function as below.
=FormatDate(DateObject();"dd/mm/yyyy hh:mm:ss")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.