Re: AGE / Birthdate

#1

DATEDIFF?

Francesco Anti

"Tonni Schmücker" <TonniSchmcker (AT) discussions (DOT) microsoft.com> wrote

Quote:

Can on calculate a given persons age, from his birthday and the
currentdate/selected date ... ??

#2

Calculated members support Visual Basic for Application Functions which
includes Datediff and Now() functions.
You can also use T-SQL Datediff as the source column for your measure (or
member name/key column for a dimension). Age will then depend on the
process date of the cube.

Francesco Anti

"Tonni Schmücker" <TonniSchmcker (AT) discussions (DOT) microsoft.com> wrote

Quote:

Sorry ... can I use datediff in a calculated member ... so that it works
on a
timedimension, and a birthday dimension ??

"Francesco Anti" wrote:

DATEDIFF?

Francesco Anti

"Tonni Schmücker" <TonniSchmcker (AT) discussions (DOT) microsoft.com> wrote in
message
news:BFE0D901-0673-417C-8AB1-017435AFDBE7 (AT) microsoft (DOT) com...
Can on calculate a given persons age, from his birthday and the
currentdate/selected date ... ??

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

Re: AGE / Birthdate

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

Re: AGE / Birthdate - 05-11-2005 , 09:08 AM

Re: AGE / Birthdate - 05-11-2005 , 10:03 AM