+ Reply to Thread
Results 1 to 5 of 5

Date does not sort

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    Geneva
    MS-Off Ver
    1902
    Posts
    3

    Date does not sort

    Date is in european format so it does not sort properly. Please support how to sort, for reference the data has been extracted from a query.

    08/05/2019 10:58
    01/11/2019 15:51
    21/08/2019 11:44
    24/04/2019 09:08
    30/09/2019 18:22
    21/10/2019 12:57
    22/10/2019 11:16
    09/07/2019 14:29
    16/07/2019 11:09
    21/10/2019 09:41
    30/09/2019 18:22
    12/09/2019 16:11
    25/10/2019 16:56
    30/09/2019 18:22
    19/06/2019 14:47
    30/08/2019 11:19
    08/05/2019 10:58

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Date does not sort

    Try using Data>Text to columns... to convert the dates into 'real' dates.
    If posting code please use code tags, see here.

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: Date does not sort

    Check that it's actually stored as datatime value (decimal). I suspect that you have it stored as text. Hence the sorting issue.

    Date formatting has no relevance in sorting, as sort is done on underlying value (smallest to largest or in reverse).

    Use text to column or formula to convert it into datetime value, rather than text.

    If you need further help, I'd recommend uploading sample workbook that mirror your actual workbook.
    Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  4. #4
    Registered User
    Join Date
    11-12-2019
    Location
    Geneva
    MS-Off Ver
    1902
    Posts
    3

    Re: Date does not sort

    Since the data is extracted by formulas, it doesnt seem to do anything ?

    =VLOOKUP($A11,'Raw pipeline data'!$A:$ZZ,10,0) (example of formula)

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: Date does not sort

    Then use formula or alter the source range using text to column. But as I quoted.
    Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

+ 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. Replies: 4
    Last Post: 09-09-2019, 12:22 AM
  2. [SOLVED] Sort only by days, not from days - months - years (custom vba date sort)
    By alexgoaga in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-16-2018, 06:56 AM
  3. Convert numbers appearing as a date into actual date in order to sort data
    By Santa1986 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2015, 12:56 PM
  4. [SOLVED] Sort date and bring current date top and run macro
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-09-2013, 11:37 PM
  5. [SOLVED] How to sort the data by item code first, then sort them by date?
    By Zecond in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-04-2013, 01:55 AM
  6. How to sort date by actual date and not first number!!
    By Brice112 in forum Excel General
    Replies: 2
    Last Post: 05-04-2010, 06:19 PM
  7. [SOLVED] the date format is not working ,sort by date doesn't work.
    By Rosa Campos in forum Excel General
    Replies: 1
    Last Post: 09-12-2005, 06: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