What document was created in an attempt to revise the Articles of Confederation?

the secretary of state, appointed by the president with the advice and consent of the senate, is the president's chief foreign affairs adviser. the secretary carries out the president's foreign policies through the state department and the foreign service of the united states.

is there a year set? the question is incomplete