Web Client-"Date Field must be in this format M/d/yyyy"

posted on February 2, 2022

We have a customer who is searching for documents where a metadata field is set to use "European Date Format dd/mm/yyyy" in the Web Client.

When using this format the results show all documents and not the specific date and there is the following message below the date field:

I see in the below post Jacob had the same issue and they had to use the Windows Client.

https://answers.laserfiche.com/questions/191622/Date-fields--web-client-cant-accept-a-2digit-year

We have tested and this is successful on our end as well. Issue is, our customer relies heavily on the Web Client and it's flexibility.

Is there a way to possibly edit a Web Client Config file to enable this search format?

WC Version-11.0.0.79

Appreciate the feedback,

Jeff Curtis

0 0

replied on February 3, 2022

The linked question is about entering a 2-digit year (e.g. "22" instead of "2022"), so it doesn't look related to me.

When you say that the metadata field is set to use European date format, I take it that you have set up a custom formatter for the Laserfiche field? That's generally not necessary as date fields follow the user's locale to properly format them for each user. As for input, that again is going to be based on user/machine settings and not on properties of the field. This allows for a consistent user experience across all date inputs in the product.

So the browser that is rejecting the 18/10/2020 input, what are the system settings for it? What language and locale is the browser set to use?

0 0

View 5 previous replies

replied on February 3, 2022

Looks like we had ESP on this and typed at the exact same time

They are in the Bahamas and below is there Regional Settings format on their Laserfiche Server, where Web Client is installed. All of their LF Servers have the same setting.

0 0

replied on February 3, 2022

Each user's settings are taken from each user's machine and browser configuration, not the server. A single Laserfiche repository is designed to handle users from any combination of locales at the same time. This is why specifying a date format at the field level is only rarely the right solution.

0 0

replied on February 3, 2022

Hey Brian,

One thing of note, the Regional setting was changed on the server after Laserfiche was installed. This is machine where we have been testing the Web Client date search.

If the setting was changed after the install, should the Web Client pick up this change or will it always refer to the setting at the time of the install?

Thanks Again,

Jeff Curtis

0 0

replied on February 4, 2022

The user's current locale and browser settings are the only thing that matter.

0 0

replied on February 8, 2022

Thanks Brian

I had a chance to look at this again with our Consultant and Columns such as "Creation Date" are still showing standard US m/d/yyyy format in the Web Client.

We confirmed that Chrome is using the "Current Region" for the browser settings which the machine we are on (Web Server) is set to the following Regional Settings:

0 0

replied on February 10, 2022

@Brian McKeever Is this a Bug or by Design....

Jeff

0 0

replied on February 21, 2022

Here is what I am seeing in the Web Client (Customer uses this 99% of the time) on two different servers with the same Regional Setting I listed in this post:

Is the Creation Date hard set for US Formatting?

Appreciate the feedback,

Jeff Curtis

0 0

replied on February 25, 2022

The locale decisions like this are made based on what is technically known as the "Language-Accept" header. Even when you change formatting settings in the OS, the browser doesn't communicate that to the web client server - we still see "en-US" as the language, and use the date format associated with that. It seems like browsers are making it harder and harder to change this value, and it can be easily confused with the setting to change the language of the browser UI.

For Edge, if you go to Settings/Languages and put English (United Kingdom) above English (United States) and log back into a repository, you should get European date formatting. I didn't see a way to do it in Firefox, but I assume it's possible.

1 0

Discussion

Discussion

Web Client-"Date Field must be in this format M/d/yyyy"

Comments 11

Follow-Ups 0

Sign in to reply to this post.