Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
farrukh98
Starting Member
1 Post |
 Posted - 2006-07-19 : 04:11:32
|
| HI I am trying to create time dimension and in that i want to create a month,week,days as levels.My dates are in string format (dd/mm/yyyy).i am writing this code in 'member key column' in dimension editor but it is given error on this.datepart(month,convert(datetime,isnull("dbo"."Status_Table"."datacom_status_date",'01/01/1990'),103)) i am using 'isnull' funcion as i have null values in my field named Datacom_Status_Date.Kindly help on this.Thanks in AdvanceFarrukh |
|
|
|
|
|
Creating Time Hirerchy in dimension editor