Current Year, Month, Day

#1

Hello all,

Is it possible to get the current year or month or day woth a function
within a calculatad member?

For example, when I want to know the current year (based on for example
the systemclock), can I use something like:

Year(Date())? Or any other function?

So I don't want to use my time dimension.

Thanks in advance.
Marco.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

#2

year(now())

--vincent

Quote:

Marco Linders<m.linders (AT) pforb (DOT) com> 7/11/2003 4:14:21 AM

Hello all,

Is it possible to get the current year or month or day woth a function
within a calculatad member?

For example, when I want to know the current year (based on for example
the systemclock), can I use something like:

Year(Date())? Or any other function?

So I don't want to use my time dimension.

Thanks in advance.
Marco.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Current Year, Month, Day

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Current Year, Month, Day - 07-11-2003 , 04:14 AM

Re: Current Year, Month, Day - 07-11-2003 , 04:39 PM