MATLAB Answers

Indexing dates yearly and quarterly.

2 views (last 30 days)
Doheon Lee
Doheon Lee on 31 Jan 2020
Answered: dpb on 31 Jan 2020
I have many tables, in which the first column is date and the second column in data.
And I want to separte these data yearly and montly.
For examply, from 2017-Jan-01 to 2017-Dec-31, and 2018-Jan-01 to 2018-Dec-31 and so on for yearly categrization. For quarterly categorization, from 2017-Jan-01 to 2017-Mar-31, from 2017-April-01 to 2017-Jun-31, etc.
As start dates and endd ates are any dates in a year, they may need to be detected first.
Please note that each yearly and quartely seprated data will be used in a loop temporaraly and deleted, so I do not need a table of yearly (or quartely) separated data.
Thank you in advance.

Answers (1)

dpb
dpb on 31 Jan 2020
Use a timetable and retime with a custom method function.

Categories

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by