+ Reply to Thread
Results 1 to 2 of 2

Not able to filter excel values with system date

  1. #1
    Registered User
    Join Date
    10-30-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    92

    Not able to filter excel values with system date

    Hi

    I have written a code where it will filter the excel rows in a sheet with which matches with the todays date
    but my code is returning 0 records though i have match with the system date.

    Please Login or Register  to view this content.
    In the above code i am refering to the sheet1 at J column with criteria as Date(which is current date) and i have record with the current date but it is not filtered with the current date.

    it was working before but suddenly i am facing this issue, can you please help me to get rid of this.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Not able to filter excel values with system date

    Isn't J1 already field 10?

    Possibly change it to Range("A1") or make it Field 1

+ 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] 1904 System Date in One Excel and Not in the Other
    By chcalissie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2014, 03:43 PM
  2. Getting system date format in excel
    By Aakansha_5 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2012, 01:58 PM
  3. Date independent of System date in column of Excel
    By gaursh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2011, 06:30 AM
  4. Replies: 2
    Last Post: 12-17-2010, 01:55 PM
  5. Negative date values without changing the Date System
    By softuser in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2007, 06:07 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