You are viewing limited content. For full access, please sign in.

Question

Insert into SQL not working when datatype "datetime"

Workflow Version 10

Updated July 21, 2017

asked on July 21, 2017

I am trying to insert data into the SQL field that has the data type of "datetime", the data values in Workflow look like this "20/01/2018 7:00:00 AM" I have pre-created the token and tagged it as "Date Time". However when I run the workflow I get the error

"The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated."

I have tried in a custom query as well. How can I get this data to store in a SQL table as datetime?

0 0

Replies

replied on July 21, 2017

Can you provide screen shots of the table set up and how your token is set up?

0 0

replied on July 21, 2017

SQL table setup

How tokens show in workflow

0 0

replied on July 21, 2017

Is the SQL set up to accept the DD/MM/YYYY format? When I do MM/DD/YYYY it works fine for me.

2 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked July 21, 2017
Updated July 21, 2017
605 views