Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDX syntax question about dates Expand / Collapse
Author
Message
Posted Wednesday, April 2, 2014 2:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 3, 2014 7:57 AM
Points: 28, Visits: 107
Hi there,

Can someone please convert the following SQL syntax to MDX?

....
....
where START_DATE > datepart(yyyy,getdate()) or
START_DATE between dateadd(m,-36,(dateadd(yyyy,getdate)) and datepart(yyyy,getdate()

Thank you,

MG
Post #1557701
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse