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 |  
                                    | davidagnew37Starting Member
 
 
                                        33 Posts | 
                                            
                                            |  Posted - 2004-08-31 : 07:30:35 
 |  
                                            | Hi, I have a Time Dimension which allows me to select a specific YEAR, or YEAR & QUARTER or YEAR & QUARTER & MONTH, or YEAR & QUARTER & MONTH & DAY. Is there any way that I can have a range of dates? Is it possible to have 2 time Dimensions for example which did the following:  a start: Year|Month for example    (>= Year|Month ).......and...... an end: Year|Month        (<= Year|Month ) Thus I would be able to select a range of dates/months.  Do you know if this is possible to write this inot the dimension?Thanks, David |  |  
                                |  |  |  |