I checked out you suggestion but I don't think it will work because even though the start term itself has a start and end date, the time period that applicants apply for it do not.

My problem now is how to create a calculated member such as

SUM({NULL:[Dim Date 1].[CALENDAR].[full date].[2013-06-21 00:00:00.000]},[Measures].[EVENT])

into

SUM({NULL:[Dim Date 1].[CALENDAR].[full date].[@full date]},[Measures].[EVENT])

I can get the hard-coded version above to work after I deploy my cube and browse the data but I only get #value for the 2nd code option. The reason I am doing this is to prepare a report in Excel 2010 so that users can easily pick a date.