Can a variable be used in record selection? I have a report that is calculating workdays and holidays based on the formula from Ken H. and is working correctly. However I want to limit my record selection based on the formula. Please help
You can use a variable in a record selection, but it will prevent the SQL from being passed to the database.
The post is too nebulous to allow for helping you, perhaps you might post intent with specifics.
The best way to handle Holidays, Weekends and Weekdays is to create a table which contains all dates, with attributes for each date stating things like that, and more. This is standard fare in Data Warehousing and gets you around the hacks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.