March 1, 2005 at 8:20 am
hi all,
i have a dimension table TimeD that stores different format of date. There's a field Timed_Date which is in datetime format e.g. 20/01/2005. However when i browse data in the cube editor, it'll display as 1/20/2005.
i've set the Timed_Date to sort by seq, another field in the same table.
i've set the date format in the regional setting in control panel as dd/mm/yyyy.
i've tried changing the key data type but it still does not display correctly.
i've tried changing the key data type to varchar but do not know how to use the convert function to customize it to the format that i want so that it'll display dd/mm/yyyy in report.
any other method i can use? it's confusing for the report to display as 1/20/2005.
thanks lotz
March 1, 2005 at 4:55 pm
Member Name Column is the one should be changed.
March 1, 2005 at 9:12 pm
how should i change it? i've tried putting in the convert function in the member name column or member key column but it says that it's invalid.
pls help. thanks.
March 1, 2005 at 9:51 pm
convert(varchar, "dbo"."TimeD"."Timed_Date", 103)
If not work, install service pack.
March 5, 2005 at 3:45 am
i'm sorie i din mention earlier. my tables are in AS400 database.
March 6, 2005 at 7:41 pm
Not sure if this helps, but you could try using the 'char' function. It would appear that the default format is US date format.
Char(X,F)
Returns the string-representation of a date, time or timestamp value, X. F is the format, (which is optional), and can be: USA, ISO, JUL or any defined system format.
Steve.
March 6, 2005 at 11:06 pm
hi steve,
where should i put the function? is it in member name column?
u mean e.g. char(ztimed.timed_date, USA) ?
thx.
March 6, 2005 at 11:15 pm
Yes, thats where I would try it.
I'm not a big AS400 user, so can't guarantee that this will solve your problem.
Steve.
March 7, 2005 at 3:59 am
i've tried but it says invalid. any suggestion?
thx...
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply