Indexing dates yearly and quarterly.

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.

Answer 1

[dpb]

Use a timetable and retime with a custom method function.