i working on the financial pattern recognition and i need to filter my extracted pattern by some date time method,
for instance, i need to preserve all patterns which occur on the same day in the entire dataset or preserve all pattern occur in the same month or in the same quarter of year.
(suppose that my dataset begins from 1-1-2017 till 1-1-2019 )
i think, if today is Sunday and i want to preserve all of Sunday in my dataset, the challenge is how to build a Date number Variable that contains all of Sundays from 1-1-2017 to 1-1-2019?!
the second question is, in order to eliminate unuseful date from my DateTime Variable is there any work possible like logical indexing to speed up my code?
thanks in advanced