[RESOLVED] formula help!

[VBKit]

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!!!

[RhinoBull]

I think you need to use DateDiff function - for sample code search forum.

[VBKit]

problem solved!

         b = nod.Text
         c = DateDiff("m", b, a)
         If c < 24 Then
         nod.Text = c & " months ago"
         Else
         c = c / 12
         d = c Mod 12
         nod.Text = c &"years and" & d & " months ago"
         End If

Thanks for your help!