AnsweredAssumed Answered

date range script

Question asked by AdamReed on Sep 5, 2014
Latest reply on Sep 5, 2014 by AdamReed


date range script


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.