10 Replies Latest reply on Sep 29, 2009 8:47 AM by mrvodka

    Portal Search

    nathan_george69

      Title

      Portal Search

      Post

      Hi

      :robotindifferent:

      I am trying to perform a search for a set of dates e.g.. ( from 01/09/09 to 30/09/09 ) and I am unable to find any records I have created. I have tried using certain operators.

       

      I am wondering if I am doing something wrong or if I need to Wright a script. Please could someone please point me in the correct direction.

       

      All help and suggestions would be extremely appreciated.

       

      Thanks and i hope that someone can help me ???

        • 1. Re: Portal Search
          ninja
            

          Howdy,

           

          The operator you want is "..." (without the quotes).

           

          Do your search, in the field of interest, for:

           

          1/09/09...30/09/09

           

          And that's assuming that FMP keeps dates as you do.

          You may want to also explore finding for

           

          9/1/09...9/30/09     but that's just a guess on my part...I don't know if field formatting of dates would extend into how a find is written...I would think it would, but never have had reason to try it out.

          • 2. Re: Portal Search
            nathan_george69
              

            Hola, Ninja

             

            Thanks for getting back to me :)

             

            I have tried out your suggestion and it is not working I have also tried rebuilding the who database but still no look.

             

            Do you have any other suggestions?

             

            Would really appreciate it

             

            Thanks

             

            Nathan_george69

            • 3. Re: Portal Search
              ninja
                

              Howdy,

               

              Silly question time:

               

              Is the field set up as a Date field?

              Can you tell me anything about how data is put into this field? (User types it in, calculation, etc.

              At this point, I don't know much about what you're trying to do, or the build that you're trying to do it on...

              When you enter the date search in my post, what happens?  Does it simply say "No records match..."?

              What is the date formatting of this field, I'll try to replicate it.

               

              More info would be useful.

              Thanks!

              • 4. Re: Portal Search
                nathan_george69
                  

                Hola, Ninja

                 

                Sorry if i was a bit bland.

                 

                1- Yes the field is set up as a Data Field

                 

                2- Data is entered into this field by a pop down calender in the form of 01/09/09.

                 

                3- I have created a booking form with Dates, names, locations ect. I need to bring up all the

                bookings from within a cirtain criteria of ( dates to and dates from ).

                 

                4- Yes when i perform a find it displays the message "No records match..."

                 

                5- all the fields in question are Date formats.

                • 5. Re: Portal Search
                  ninja
                    

                  OK, thanks.  Honestly it looks right to me, so let's try a basic test on this.

                   

                  Create a new record in the database.

                  Fill in the date field using the dropdown calendar and select the date September 15, 2009.

                  This should populate your field with 15/9/09 if I'm not mistaken.  If this is not the case, please post.

                   

                  Enter find mode via the drop down menus on top.

                  enter 1/9/09...30/9/09 with no spaces into that same field

                  hit the enter key (or the Find button on the toolbar)

                  From what you describe, you should get no matching results...but in actuality, you should get at least the record you just made.

                   

                  If you get no matching record, do the same find, the same way, but search for:

                  9/1/09...9/30/09

                   

                  Let me know what you find.

                  On the side, I'm wondering if you have a different language version and, if so, what tweaks were possibly made around the dates...I cannot format my dates as you have them (on FMP8 on WindowsXP-SP3).

                  If this is a possible cause, I trust that someone with familiarity with such an issue will join the thread.

                  • 6. Re: Portal Search
                    RSchaub
                      

                    Fields

                     

                    Date_Of        //Record Date

                    Start_Date   //Global

                    Stop_Date    //Global

                     

                    Relationship name = Date_Search

                     

                    Date_Search [Date_Of]  ≥  Main_Table Start_Date

                    Date_Search [Date_Of]  ≤  Main_Table Stop_Date

                     

                     Place

                     

                    Start_Date

                    Stop_Date

                     

                    Next To Date_Search Portal Enter Start Date and Stop Date, All Records from start to stop dates will appear in portal.  

                     

                     

                    • 7. Re: Portal Search
                      nathan_george69
                        

                      Hola, Ninja

                       

                      Thanks Loads i will get back A.S.A.P

                       

                      :) thanks for shedding some light on the situation

                       

                      Nathan_george69

                      • 8. Re: Portal Search
                        nathan_george69
                          

                        Thanks M8t you are an absolute star you have solved my problem :)

                         

                        i cant thank you enough

                         

                        thanks

                        • 9. Re: Portal Search
                          nathan_george69
                            

                          Hi,

                           

                          I was just wondering now that we have got over that hurdle.

                           

                          Is there any way of intergrating into filemaker a calender view or posibly into a calender client like ( Microsoft Outlook 2007 ).

                           

                          This world really boost the operating eficiancy of my system.

                           

                          Thanks

                          Nathan_george69