When did The Constitutional Convention and the new US Constitution take place?

The Constitutional Convention took place from May 25 to September 17, 1787. The new US Constitution was adopted on September 17, 1787.