From further investigation I found a solution. Simply check the node value before assignment as follows:
// Insert Date
DeleteNil(xnNewRow.SelectSingleNode(''my:Today'', this.NamespaceManager));
xnNewRow.SelectSingleNode(''my:Today'', this.NamespaceManager).SetValue(formatDate(DateTime.Now, ...