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

Question

Question

SQL Query - Field changes date format

asked on December 14, 2017

I have a Form that has a Single Line Field that is populated (via SQL Query) with a value similar to this = 2017-10-16 00:00:00.000

However, the Form field changes the value to = 10/16/2017 12:00:00 AM

If I copy and paste the value direct from the SQL table the value stays as = 2017-10-16 00:00:00.000

Is there something I can do in the form configuration? Or a Stored Procedue? Surely it must be possible to tell the form to keep the value in plain text or something?

 

Thanks in advance

0 0

Replies

replied on December 15, 2017

I think this discussion will provide the answer you are looking for. https://answers.laserfiche.com/questions/78409/Incorrect-date-format-for-date-field-in-submitted-form#78547

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.