Date filters
When filtering either a measure column with date values (click on the column header and select Filter rows) or Time dimension members on rows (click on Time dimension member row header and select Filter time) you can use either the exact date name or relative date descriptions.
For other options for filtering data by date or period, see filtering time.
Exact dates
When specifying a date filter you can specify a date in different formats, e.g. Dec 14 2012 or 2012-12-14.
If you specify just the month (Dec 2012), then it will be the same as the first date of the month (Dec 01, 2012).
If you specify just the year (2012) then it will be the same as the first date of the year (Jan 01 2012).
Relative date ranges
If you click on date columns and select Filter rows / between or if you put Time dimension on rows and click on the year, quarter, month, week or day row header and select Filter by name / between then you can enter a dynamic date range that will be calculated from the current date.
For example Time between
30 days ago and today1 week ago and 3 months from nowlast wednesdaybeginning of last month and one day before first day of current month
