Selecting date range
Ahmad Faisal Ahmad Zaki last edited by
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 last edited by
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.