2 Replies Latest reply on Sep 5, 2014 12:32 PM by AdamReed

    date range script

    AdamReed

      Title

      date range script

      Post

      I've looked at and tried a number of date range scripts but am for some reason having trouble making them work.

      I have a date field that should not change (it's the publication date of a book) and am interested to be able to perform a find which will allow users to display records for which that field is within a desired range, but by default  I would like to show records for which that date field is within six months prior of the current date and also include all dates in the future and records for which no date is set.  So I think I want to omit records prior to six months of the current date, and allow this to be overridden by users.  I've tried a few of the scripts suggested, but am really a novice.  I have defined two global fields in an unrelated table (so the haven't been able to get them to work.

      Any help would be much appreciated.

      Thanks,

      Adam