PDA

View Full Version : Need help mdx Syntax



clasixjim
05-05-2008, 12:35 PM
Hi All,

Thanks For ur consideration,

"select to_char(day_date,'DD/MM/YYYY') from Date_time"

How do write same(Sql query Mentioned above) query in mdx format.Can u please anybody
help me.

Thanx,
jim

fjlauer
05-08-2008, 02:56 PM
StrToMember("[Time].[Time].[Date].&["+format(dateadd("d",-1,now()),"dd/mm/yyyy")+"]")