Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Selecting date range

    Help wanted · · · – – – · · ·
    2
    2
    67
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Ahmad Faisal Ahmad Zaki
      Ahmad Faisal Ahmad Zaki last edited by

      Hi all,

      I have this CSV file, obtained from SQL server that containing about 6 million lines of data comprising from January - June 2022.

      Right now, I need to make average value from selected date range, e.g. 01-01-2022 until 07-01-2022.

      Is there any ways where I can filter out and copy it later to the spreadsheet so that I can make the average from there.

      Thank you in advance.

      Neil Schipper 1 Reply Last reply Reply Quote 0
      • Neil Schipper
        Neil Schipper @Ahmad Faisal Ahmad Zaki last edited by

        @ahmad-faisal-ahmad-zaki

        The answer is yes, there are ways to retain or copy only records in a date range (although I suppose there are date representations that would make it cumbersome).

        If there’s exactly one date format used by SQL someone else may be able to reply with details. Otherwise, see the FAQ and provide representative sample data.

        Also, I suppose you’re aware that data extracted from a db can undergo date filtering at extraction time.

        1 Reply Last reply Reply Quote 1
        • First post
          Last post
        Copyright © 2014 NodeBB Forums | Contributors