|
For this example, I want to create a prompt in a prompt page that looks something like this:
or
(?p_Period? = 'PrevWeek' and [Date] between _add_days (current_date,-7-_day_of_week (current_date,1)) and _add_days (current_date,-1-_day_of_week (current_date,1)))
or
(?p_Period? = 'WTD' and [Date] between _add_days (current_date,-1-_day_of_week (current_date,1)) and current_date)
or
(?p_Period? = 'MTD' and [Date] between _first_of_month (current_date) and current_date)
or
(?p_Period? = 'Yesterday' and cast([Date],date) = _add_days (current_date,-1))
or
(?p_Period? = 'Range' and [Date] between ?p_Begin? and ?p_End?)