How can I set a prompt tp automaticaly display the last week day Monday, Tuesday, Wednesday, Thursday, Friday? Not Saturday or Sunday. I need to create reports and the date selection must be yesterday. If today is Monday yesterday was Saturday or Sunday I need it to be Friday.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you automaticaly set a prompt to display the LAST WEEKDAY
- Thread starter JohnBOA
- Start date
For Impromptu this would have to be done in a macro, as Impromptu itself does not allow for dynamic prompts.
In the macro, use the Weekday() function to determine the current or closest prior weekday (return value of 2 - 6) and populate a prompt variable in a dialog box function. This is a special function that is used to populate dialog variables and to set dialog box control values and attributes.
HTH,
Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"![[pc2]](/data/assets/smilies/pc2.gif "[pc2] [pc2]")
In the macro, use the Weekday() function to determine the current or closest prior weekday (return value of 2 - 6) and populate a prompt variable in a dialog box function. This is a special function that is used to populate dialog variables and to set dialog box control values and attributes.
HTH,
Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
- Status
Similar threads
- Locked
- Question