Is there a way for a dataviews query output go to the notes text?

For example in my daily note I want to list my active projects, the active projects will eventually be closed projects and not meet the criteria. But I would like to be able to go back to a given day and see what projects were active on that day.