4 Replies Latest reply on Jul 10, 2013 10:46 AM by Dees

    Find records between date range

    Dees

      Title

      Find records between date range

      Post

           I have  a table called sales. In this table there is a field called date ( it is creation date ) . In this table I did a find to find recrds with the following date ranges

           a)  6/24/2013...6/28/2013 - got the results

           b) 7/1/2013...7/7/2013 - got the results

           c) 6/28/2013...7/5/2013 - get a modify find box. It does not search for these dates. Why and how do I fix it.

            

        • 1. Re: Find records between date range
          philmodjunk

               It's possible that a) and b) will produce results where c) will not simply due to the fact that the date ranges are different.

               Example:

               If you had two records in your table with these dates:

               6/27/2013
               7/6/2013

               then a) and b) will find records but c) will not.

          • 2. Re: Find records between date range
            Dees

                 There are records for almost each date. Isnt ... operator a date range operator. 

                  

                 If I had records with the follwoing dates:-

                 6/27/2013

                 6/29/2013

                 6/30.2013

                 7/2/2013

                 7/3/2013

                  

                 and In the find I put the range as 6/28/2013...7/3/2013... should I in theory receive the records with the follwoing dates:-

                 6/29/2013

                 6/30/2013

                 7/2/2013

                 7/3/2013

                  

                 How do I make that happen?

            • 3. Re: Find records between date range
              philmodjunk

                   A date range criterion will not work as expected unless the field where the criterion is specified is of type date, not text. Use Manage | Database | Fields to make sure that this is the case for your date field.

              • 4. Re: Find records between date range
                Dees

                     Thanks - that helped.

                                
                               Preferences
                §
                1
                2
                3
                4
                5
                6
                7
                8
                9
                0
                -
                =
                Backspace
                                     
                Tab
                q
                w
                e
                r
                t
                y
                u
                i
                o
                p
                [
                ]
                                          
                Return
                                          
                                     
                capslock
                a
                s
                d
                f
                g
                h
                j
                k
                l
                ;
                '
                \
                                     
                shift
                `
                z
                x
                c
                v
                b
                n
                m
                ,
                .
                /
                shift
                                     
                                          
                                         English
                                               
                                               
                alt
                alt
                                     
                                
                               Preferences