AMSX Scripting Language - Command : selectsinglenodedate

Summary

Select a single XML node and return its value as a normalised date string

Description

Finds the named node in the loaded XML document and converts its inner text to a SQL-parseable date string. Use this instead of SelectSingleNode when the XML may contain locale-specific date formats such as dd/mm/yyyy or mm/dd/yyyy that SQL Server cannot parse directly.

Parameters

Syntax

SelectSingleNodeDate "node/field name (will be auto-tagged using FieldTag)"