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!
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.