What is the oldest Advent hymn?
The Song of Mary, commonly know as the Magnificat is recorded only in Luke's Gospel and the words are spoken during a visit to her cousin, Elizabeth while they are both pregnant - Elizabeth with John the Baptist and Mary with Jesus.
The Magnificat is one of four hymns, distilled from a collection of early Jewish-Christian canticles, which complement the promise-fulfillment theme of Luke's infancy narrative. These songs are Mary's Magnificat; Zechariah's Benedictus (1:67–79); the angels' Gloria in Excelsis Deo (2:13–14); and Simeon's Nunc dimittis (2:28–32). In form and content, these four canticles are patterned on the "hymns of praise" in Israel's Psalter. In structure, these songs reflect the compositions of pre-Christian contemporary Jewish hymnology. (https://en.wikipedia.org/wiki/Magnificat)
Text from the book of Luke
Luke 1:46-55 And Mary said, “My soul exalts the Lord, and my spirit has begun to rejoice in God my Savior, because he has looked upon the humble state of his servant. For from now on all generations will call me blessed, because he who is mighty has done great things for me, and holy is his name; from generation to generation he is merciful to those who fear him. He has demonstrated power with his arm; he has scattered those whose pride wells up from the sheer arrogance of their hearts. He has brought down the mighty from their thrones, and has lifted up those of lowly position; he has filled the hungry with good things, and has sent the rich away empty. He has helped his servant Israel, remembering his mercy, as he promised to our ancestors, to Abraham and to his descendants forever.” (New English Translation)
English Text of the Magnificat
My soul doth magnify the Lord,
and my spirit hath rejoiced in God my Saviour.
For he hath regarded the lowliness of his handmaiden.
For behold, from henceforth all generations shall call me blessed.
And his mercy is on them that fear him throughout all generations.
He hath shewed strength with his arm.
He hath scattered the proud in the imagination of their hearts.
He hath put down the mighty from their seat
and hath exalted the humble and meek.
He hath filled the hungry with good things.
And the rich he hath sent empty away.
He remembering his mercy hath holpen his servant Israel
as he promised to our forefathers Abraham, and his seed forever.
Amen.
(https://www.andrews.edu/~mack/pnotes/magnificat.html)
The Magnificat performed by the University of Michigan Chamber Choir.
Interesting reflections by Dietrich Bonhoeffer on the Magnificat and what it tells us of Mary.