Has anyone managed to delete a value in a data field using Calculate Data rules in Data Translation Services?
Have tried a number of standard vbscript values for RetValue including "Null", "0", "Empty" and even "00/00/0000 00:00:00", both with and without the quotes.
At the moment the only workaround seems to be a ficticious date - 01/01/2100.
LANDesks interpretation of vbscript is strange in that everything must be in a single line. A CR will cause the rule to fail. Also, there appears to be no documentation for this non-standard implementation.
Any ideas will be most welcome.