A date calendar is commonly used for users to select a date range. A calendar widget is available in many front-end reporting tools. Many reporting writers prefer to use the calendar widget because it is easy to use in the reporting tool and report users are familiar with it.
Dates that come from the calendar widget are typically in the form of strings, for example, 7/29/2016, which might or might not be a valid date member in the
In this recipe, we will show you how to format the dates from the calendar widget in the reporting tool as a valid date member and then create an MDX query to take the ...