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

Question

Insert Date into SQL

Workflow

Updated January 7, 2018

asked on January 5, 2018 • Show version history

Form has a date value of mm/dd/yyyy but SQL has yyyy-dd-mm 00:00:00.000 - is there a way using the Workflow's Insert Data function to make this insert work?

0 0

Replies

replied on January 5, 2018

In my experience, if you pass a date token/value to SQL through the Insert Data activity, any format conversions will be handled automatically.

For example, I have several processes that pass formatted dates like 12/1/2017 and SQL stores it in the default format without me needing to make any alterations.

As long as it is recognized as a valid date, you should be fine.

2 0

replied on January 7, 2018

I completely agree with Jason here.

However, you can change the field's format in forms easily to yyyy-dd-mm in the admin console!

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked January 5, 2018
Updated January 7, 2018
740 views