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?
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/
Great information. Thank you very much from the bottom of my "new user" heart!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.