+ Reply to Thread
Results 1 to 7 of 7

Search (filter search) a date value

  1. #1
    Registered User
    Join Date
    08-25-2015
    Location
    HCM
    MS-Off Ver
    2010
    Posts
    15

    Search (filter search) a date value

    Hi all,
    I have a column data with date format. When I filter this column and want to use 'search' in filter function, I cannot search a specific date e.g. 12/09/2018.
    What I can search is a part of date: either day (12), either month (09) or either year (2018).
    Any way that can help me to search a specific date (12/09/2018) in excel filter function? Thank you.

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,192

    Re: Search (filter search) a date value

    Hi

    I suppose you should create new columns with day(date) and month(date).

  3. #3
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Search (filter search) a date value

    Hey Navafolk,

    You can do it with the help of VBA.

  4. #4
    Registered User
    Join Date
    08-25-2015
    Location
    HCM
    MS-Off Ver
    2010
    Posts
    15

    Re: Search (filter search) a date value

    Quote Originally Posted by José Augusto View Post
    Hi

    I suppose you should create new columns with day(date) and month(date).
    Thank you Jose, That will take me 3 times of search in 3 columns, too much time consuming. Is there any efficient way, find in one search?
    Last edited by navafolk; 10-21-2018 at 10:11 PM.

  5. #5
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,192

    Re: Search (filter search) a date value

    Hi

    I suppose there is no other way to solve your problem.

    See that the dates are integer values (when used only as a date and not as a date and time).

    The 22-10-2018 corresponds to the number 43395 and as September and 30 days the 22nd of the previous month will correspond to the number 43365 and 22-08-2018 corresponds to 43334.

    Since there is no uniform relation, for example from thirty to thirty days, day 22 happens, and since it is not possible to use functions in the filter itself, it does not seem possible to do it in any other way.

  6. #6
    Registered User
    Join Date
    08-25-2015
    Location
    HCM
    MS-Off Ver
    2010
    Posts
    15

    Re: Search (filter search) a date value

    Thank you then. I'll stop research this.
    Last edited by AliGW; 10-26-2018 at 02:32 AM. Reason: Unnecessary quotation removed.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,041

    Re: Search (filter search) a date value

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to replace specific text search for any date search
    By katiedee1625 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2018, 11:22 AM
  2. Macro to search/filter raw data within date range
    By iqbal.88 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-17-2018, 10:47 AM
  3. Replies: 4
    Last Post: 11-08-2014, 04:57 AM
  4. Search column for string and date then search adjacent cell and pop up message
    By ftwobtwo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2014, 09:55 AM
  5. VBA Code - Search text & search number & search qty and result - Urgent Please
    By naresh73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2014, 10:51 AM
  6. [SOLVED] Macro/s to create Search Bar to filter to search terms entered activated by Command Button
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2013, 03:44 PM
  7. Great Combo Filter/Search form, cant get DATE filter to integrate. HELP
    By fau5tu5 in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2009, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1