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

Question

dates to database

Forms

Updated April 4, 2023

asked on April 3, 2023

Hi,

I have a date field in forms and a workflow inserts the data into a SQL table. There is no issue as long as the date is "today's" date or a future date, but if the date is an earlier date than the date I'm completing the form I get 1900-01-01 as the date in the SQL table.

Does anyone have any suggestions?

thank you

Lucinda

0 0

Replies

replied on April 4, 2023

I had to look a bit but I found where to set the data type for token, thank you!

1 0

replied on April 3, 2023

Does your workflow report any errors when inserting the date into SQL?

0 0

replied on April 4, 2023

No error messages, caught the issue when I checked the data imported into the table.

0 0

replied on April 4, 2023

When I insert a date value in to a SQL table, I always format the date token to 'yyy-MM-dd'.

Have you tried that on your workflow?

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked April 3, 2023
Updated April 4, 2023
111 views