2 Replies Latest reply: Jun 19, 2012 11:30 PM by ajs_developer RSS

    Selection - Selecting every date before a selected date

      Hi There,

       

      I'm trying to build a report where users can see all data from before a date that they select.

       

      I don't want to have users select multiple dates from a list box, i'd like for them to select one date and have the system also select every date before it so that they get the complete set.

       

      I believe the best bet would be a macro, but i wanted to see if there was a better solution.

       

      I've searched the forum and come up empty, so my guess is this is either so easy no one has ever had to ask OR it's impossible.

       

      Any help you guys can provide is most appreciated.

       

      Cheers,

      Ben.