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="Ded" type="vbDateTime"> 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="Ded2" type="vbdatetime"> Ded+14 </SET>
Where Ded2 is another date variable.
Thanks,
Haresh
hmelwani@sdnllp.com