Selecting date range
-
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.
-
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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login