My date dimension is in the format below with ~ operator. Its a flat dimension with month ends. So all members are level 0 members.
and so on.
I have used Substring as well as DatePart functions in mdx member formulae.
- Substring([Date].CurrentMember,1,4) - failed during formulae verification
- DatePart([Date].CurrentMember,DP_YEAR) - verified successfully but during retrieval threw error "Invalid date spedified in function [DatePart]"