+ Reply to Thread
Results 1 to 2 of 2

Filter yesterday onwards

Hybrid View

cmb80 Filter yesterday onwards 11-13-2017, 05:20 AM
NeedForExcel Re: Filter yesterday onwards 11-14-2017, 02:29 AM
  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Filter yesterday onwards

    Hi all, I have a data set that I want to automate daily, I need to filter (show) only content from yesterday onwards. Dates are in Column A.

    I have the code below, but this seems to filter in American date format - for instance if I run it today, I see data from 11th December onwards rather than 12th November.

        Sheets("Data").Range("$A:$BE").AutoFilter _
        Field:=1, Criteria1:=">=" & Date - 1
    '
    The column is stored as UK date format data


    Can anyone assist

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Filter yesterday onwards

    Maybe your time zone is set to American instead of UK?

    The Date function will return your PC date
    Cheers!
    Deep Dave

+ 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] Extract 5th string onwards but exclude 6th string onwards if found a specificlist of words
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-07-2016, 03:48 AM
  2. [SOLVED] Hide Columns IF Row 2 onwards is Blank
    By Wheelie686 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-01-2015, 04:45 PM
  3. [SOLVED] Hide columns if empty from Row 3 onwards vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2014, 03:41 AM
  4. [SOLVED] VBA code to select today() onwards from filter
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-18-2014, 06:39 AM
  5. [SOLVED] Yesterday Date Filter
    By Angelfish13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2013, 03:08 PM
  6. Sum values from a certain date onwards
    By manny_cb in forum Excel General
    Replies: 3
    Last Post: 08-13-2010, 02:19 AM
  7. Sorting from row A6 onwards
    By teebird in forum Excel General
    Replies: 2
    Last Post: 05-18-2007, 02:46 AM

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