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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MM/YYYY prompt in 7.4 impromptu
- Thread starter Sidney786
- Start date
How about using a Report Picklist in the Prompt Manager?
Create a picklist report that shows a MM/YYYY format prompt, but uses a datetime field in the main report's filter.
Base the picklist report on a numbers table and use add-months function on curdate() (or whatever the current date function you have) to create the required date range.
soi là, soi carré
Create a picklist report that shows a MM/YYYY format prompt, but uses a datetime field in the main report's filter.
Base the picklist report on a numbers table and use add-months function on curdate() (or whatever the current date function you have) to create the required date range.
soi là, soi carré
- Status
Similar threads
- Locked
- Question
- Locked
- Question