Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Sarastro
2013-10-23T11:14:36Z
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?
Sarastro attached the following image(s):
Sponsor
Forum information
Support
2013-10-23T11:48:33Z
Please uncheck the "Validate value" checkbox.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
browndogger
2018-05-09T20:10:41Z
Seems like a bug to me. Why not fix it?
Support
2018-05-16T10:35:42Z
Originally Posted by: browndogger 

Seems like a bug to me. Why not fix it?



Please try this build if validation is better: https://www.visualcron.c....aspx?g=posts&t=7901 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top