Zoomed Image

AMSX Scripting Language - Command : sqldate

Summary

Execute a SQL statement and return the result as a date value

Description

Runs a SQL statement and stores the result in the date result buffer (mdatResultDate) rather than the string result buffer. Use when assigning to a date-typed variable so that downstream date arithmetic works correctly.

Parameters

ParameterDescription
cmdSQL statement that returns a single date value

Syntax


SqlDate "SQL statement that returns a single date value"

Return to the AMSX Command Reference