I am having difficulties setting a date-time parameter for a SQL stored procedure task and require some help.
I am creating a task to run a SQL store procedure that requires an Input parameter of type DateTime. Visualcron is asking for the value to be formatted as string format yyyymmddhhmmss. When I enter a value, for example today’s date & time (23 Oct 2013 1:50pm 30 sec) as 20131023135030 or use function {DATEFORMAT(yyyyMMddhhmmss)} it returns the following Parse error:
Could not parse value – please alter value or change data type!
Correct format for this datatype: Date data in the format
yyyymmddhhmmss (SQL_TYPE_TIMESTAMP).NOTE - I have attached a screenshot of the problem
What am I doing wrong?
Edited by user
2013-10-23T11:19:39Z
|
Reason: Not specified
Sarastro attached the following image(s):