I have two dates in a table, start date and end date. I want the user to be able to select a range, and have it select all records that are assocated with that range. Is there a way to do this, even in a macro? I have been successful in getting it to select over a range by only looking at the start date of the record. Unfortunately, there are records not being selected that should be because the specified end date would qualify it for the selection.
Hi Therese, Try using the intervalmatch() function to create date intervals, you could generate all the dates between your very starting date and the last ending date. And so your selections in those fields would be applyed to the calendar. I hope this help you.