Question

Custom-formatted date field not converting properly

Laserfiche Version 9

Updated August 22, 2014

asked on August 22, 2014

We are wanting to have our date fields in Laserfiche in the following format:

2014/08/22

Under Field Format, we went into Edit Format, and changed the format to the following:

Custom [YYYY/MM/d]

Despite doing this (and having the sample match what we were expecting), strange things happen when filling in this field. Specifically, if I enter in 20140822, it gets automatically formatted into 20/14/0822 (despite the year being specified at the front). It appears to convert properly if I enter in 08222014, but we wondered why we can't enter in the date value in the same order/fashion as we specified in the field formatting?

0 0

Answer

SELECTED ANSWER

replied on August 22, 2014

I feel like it has to do with the settings for the default date formatting on your local machine. take a look here and see if you think that might effect it:

http://www.7tutorials.com/customize-date-time-and-all-related-settings

0 0

Replies

replied on August 22, 2014

Your feelings are bang on - changing the format of my local date and time settings changed how the input is handled in Laserfiche.

I wonder if there's any way you could turn off the date field's dependency on the user's local date and time settings?

0 0

replied on August 22, 2014

Nah, probably not. Sometimes these things need to use something. At first I thought it was something in the administration console, but then i realized that the formatting is being done locally and likely formatting improperly because of a local settings.

0 0

replied on August 22, 2014 • Show version history

The format pattern only controls display and not how dates and times are parsed. The reason this is the case is because customizable format patterns can result in date strings which are very difficult or impossible to parse. For example, you can use a format that only has a year or month, that displays the quarter, repeats components, has fixed strings, etc.

As mentioned by other posters, the locale settings in Windows on the workstation where the client runs (not the server) control how the clients parse dates and times. Those locale settings also influence how dates and times are displayed, but as you've seen the defaults can be overridden in Laserfiche.

0 0

You are not allowed to follow up in this post.

Question

Question

Custom-formatted date field not converting properly

Answer

Replies

Sign in to reply to this post.