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

Question

Question

Correctly Formatted Date Field on Submission

asked on January 17, 2018

Hey everyone,

I'm dealing with an issue that is pretty frustrating in that it seems so simple to fix, but does not work correctly. I imagine I could get it to work with a workaround (workflow plus an added, hidden field on the form), but that seems like overkill for the problem here.


We have a simple "Date" field in our form. In it, you can change the format. I want it to be MM/dd/yyyy, so that, for example, on January 17th it would show 01/17/2018. So, I change it in the options there. And when I pull up the form, it appears to fill the field correctly. However, when I then submit the form, it changes the formatting of that field in the variables to 1/17/2018!

This is an issue because once the form is submitted, we file it in a folder using that variable, and the folders are out of order as a result since it's not including the 0 in front of the 1. Anything I'm missing here? Is there some way to force Laserfiche to retain our desired date formatting upon submission?

0 0

Answer

SELECTED ANSWER
replied on January 17, 2018

Hi Ryan,

On your Forms Server computer, edit the C:\Program Files\Laserfiche\Laserfiche Forms\Forms\bin\RoutingEngineServiceHost.exe.config file. Make sure that the DefaultDateFormat and/or the DefaultDateTimeFormat uses MM/dd/yyyy. Also make sure that UseSystemDateTimeFormat is set to false. Now when you save the form submission to the repository, the date variable value should use the specified format in the config file.

Regards

1 0
replied on January 23, 2018

Doing this alone did not work - but restarting services after helped. :) Thank you Alexander Huang.

0 0
replied on January 23, 2018

Worked like a charm, thanks! It is worth noting for anyone else having this problem... I needed to change that UseSystemDateTimeFormat from "True" to "False," then had to restart the Forms Routing Service in order to get it to work. Appreciate the help!

0 0

Replies

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

Sign in to reply to this post.