How to increment a date by 14 days using XML

[hmelwani]

Hi:
I have a user-entered string as 8/7/03. I would like to convert this to date and increment it by 14 days, in a *.xml file.

I am very new to XML. Any assistance would be greatly appreciated.

Thanks,

Haresh
hmlewani@sdnllp.com

 

[palbano]

You can edit the XML file with any ASCII file editor

-pete

 

[hmelwani]

Yes, I am using Notepad, but I need help with the syntax.

I have used the following to convert the string to date:
<SET name=&quot;Ded&quot; type=&quot;vbDateTime&quot;> Transaction.Comment </SET>

Where Transaction is the table name in a SQL 2000 database, comment is the field name,and Ded is a new date variable.

I have tried to following code to add 14 days, but it returns the value of 14, as the result:
<SET name=&quot;Ded2&quot; type=&quot;vbdatetime&quot;> Ded+14 </SET>
Where Ded2 is another date variable.

Thanks,
Haresh
hmelwani@sdnllp.com