2 Replies Latest reply on Apr 13, 2011 2:46 AM by LaRetta_1

    Date Range

    lynton

      Title

      Date Range

      Post

      I would like to find records based on a date range (ie) all records from 4/12 to 4/15

        • 1. Re: Date Range
          beckett85_1

          You Just have to use spaces between your search fields

          in your example above you would just use the following in the date field in find mode

          >4/12/yyyy < 4/15/yyyy

          or if its to include those dates use ≤

          • 2. Re: Date Range
            LaRetta_1

            "I would like to find records based on a date range (ie) all records from 4/12 to 4/15"

            This really isn't enough information to assist.  Would this be in a script, manually?   Would you want global fields so a User can specify the range? 

            You can specify search as:

            4/{12...15}

            Which will find records for the current year or:

            4/{12...15}/2010

            You can also specify a range as:

            4/12/2010...4/15/2010

            or

            4/12..4/15 (for current year

            I ask whether this is to be scripted because the best solution (and calculation) would depend upon more information but I hope this helps.

            NOTE:  You can use .. or ... between ranges; both are valid.  However, if you are searching for decimal numbers, you must use ... otherwise FM can produce seemingly inconsistent results.