Add a fuzzy date option of "Today" in Query.
This would allow for selecting relationships that are valid as of today without having to use "ask" parameters in query. We always have to specify the relationship date from as less than or equal to today, and the end date as greater than or equal today. This especially becomes a problem with NetCommunity as it will not work with ask parameters.
YES! This is a huge issue for us as we move forward. Seems like something that would have been implemented by now.
Perfect! I have a report that I generate for our staff meetings that requires the last two weeks from "today" and I cannot automate the report creation because I have to go change the date range manually.