How to get the date values

Question

Last month last date .. ?

Current month last date, ?

Next month last date, ?

How many days from 1st jan 2011 to current date, ?

1st quarter 1st day name and date,1st quarter last day name and date, ?

every quarters,1st half 1st day name and date,last day name and date, ?

this year first day name and last day name, ??

current week ??

Answer 1

Hi,

you should provide some background information, for example how is your date table structured.

---

Best Regards. When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer. This helps us build a healthy and positive community.

Answer 2

If your querying the dimension then there are some predefined mdx jey words that can be used.

try going thru the below link

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/d4563032-3760-4d1f-b167-34023e83ef9b/