Prompts and a Date Range

Reply
Contributor
Posts: 42

Prompts and a Date Range

I have a data table that I queried and developed prompts.

One prompt is a Date prompt that ask for a beginning date and ending date.

The date format in the field I'm prompting is mm/yyyy (04/2013).

I formatted the Prompt as "Date Range" "Day" Type.

In the Query filter the Date Prompt is "Range".

When I run the prompts, it totally ignores the beginning and ending dates in the date range.

Any ideas?

Occasional Contributor
Posts: 18

Re: Prompts and a Date Range

Here's a blog post I wrote about using date range prompts - it might help you figure out where the issue is:


http://www.bi-notes.com/2011/12/prompts-how-do-i-use-a-date-range-prompt/


Contributor
Posts: 42

Re: Prompts and a Date Range

Great information. Thank you very much from the bottom of my "new user" heart!

Ask a Question
Discussion stats
  • 2 replies
  • 233 views
  • 2 likes
  • 2 in conversation