Announcement

Collapse
No announcement yet.

Quicksearching dates

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Quicksearching dates

    Can Quick Search be used with date fields?

    Entering a date in quicksearch in a grid doesn't return the corresponding records .

    Also, if I edit the grid and in "Search>Quick Search>Select Fields" I select only dates fields, the quick search box will disappear from the grid when run.
    Last edited by robydago; 02-08-2016, 04:55 AM.

  • #2
    I was trying to accomplish the same thing, with no success.

    Possible Workaround: Adding the date field to a dynamic search and selecting appropriate criteria.

    Some of the search criteria (at least for dates) seems strange - either a bug or a feature, depending on your view

    If you want to search for records between certain dates (date 1 -> date2), if seems that the logic is >= date1 and < date 2. So to include date2 records, you would need to add a day to the end date2 to include those records.

    Perhaps someone else has a better experience with quicksearch (or a better workaround).

    Comment


    • #3
      Originally posted by robydago View Post
      Can Quick Search be used with date fields?
      Quick search can not directly handle date fields, but you can use quick search and advanced search on the same grid. As a workaround for quicksearch you can use a select statement with a date field and format that as a text string ... .
      Best regards: - Reinhard -

      I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

      Comment


      • #4
        Your workaround is a good idea.
        Thanks.
        Still it would be much better if quicksearch worked with dates.

        Comment


        • #5
          Originally posted by robydago View Post
          Your workaround is a good idea.
          Thanks.
          Still it would be much better if quicksearch worked with dates.
          I'm with you too, I'd prefer a lot to write a single year and that searches the matching dates of the grid datetime fields... It's a pitty that doesn't work.

          Comment


          • #6
            Hope this will be solved with sc9!

            Comment


            • #7
              I just discovered that neither QUICK SEARCH or ADVANCED SEARCH does not work correctly. So any ideas when this will be fixed ???

              Comment


              • #8
                Originally posted by bradk View Post
                I was trying to accomplish the same thing, with no success.

                Possible Workaround: Adding the date field to a dynamic search and selecting appropriate criteria.

                Some of the search criteria (at least for dates) seems strange - either a bug or a feature, depending on your view

                If you want to search for records between certain dates (date 1 -> date2), if seems that the logic is >= date1 and < date 2. So to include date2 records, you would need to add a day to the end date2 to include those records.

                Perhaps someone else has a better experience with quicksearch (or a better workaround).
                There is no logic because for me the DATE2 works Ok but DATE1 is not wqorking at all so all records with date < than DATE1 still show up

                Comment


                • #9
                  OK, so NetMake confirmed that Quick Search is not working with dates. So what now ?
                  If this is a bug or missing feature it still needs attention because this is so basic, right ?

                  Comment

                  Working...
                  X