Hi I need an urgent help for you…

I need to change the display for a field returned from an old XML and put it on to a new .XML file.

Currently I have the following to block the date to be displayed, “-“ is displayed for each field as a result.

Set oDoc = New DOMDocument
oDoc.loadXML xmlstring
Set nodList = oDoc.selectNodes("//date")
For Each nod In nodList
nod.Text = "-"
Next

How I need to work out now is instead of displaying “-“, I need them to be more details, compared to the current date. For example, if the date is “01/01/08”(this is the format in the old .xml), it will show “6 months ago”, and if the date is “20/01/07” it will show “18 months ago”. I can’t figure out a formula to compare months… and how can I get the value of <date> from the old .XML?? can someone please help.!! Thanks!!!