Question

Forms date format issue

Forms Version 10

Updated March 19, 2021

asked on March 8, 2021

We have a client that brought this to our attention and it seems to check out that this is default behavior. They are on Forms 10.4.5.282 and questioned if they could change the date format on the columns within their inbox. There is a column called 'Date assigned' which shows as "8 Mar" if it was assigned today. The Due date is displaying as "12 Mar 2021 17:00" if due date is March 12th. Then the instance start date is "8 Mar". If the date is from a previous year then wherever it uses day and month, it changes to day/month/year. (See screenshots)

Customer would like to make these date formats standard across all columns. Is this something we can do manually in a config file somewhere?

Thanks

Instance Start Date.PNG (10.36 KB)

| Download

Due Date.PNG (29.56 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on March 19, 2021

The workaround you can use is following:

Find the itemGridColumn.factory.js under "C:\Program Files\Laserfiche\Laserfiche Forms\Forms\js\app\inbox" and replace "lfdateCached:\'customDate\'" and "lfdateCached:\'customDateTime\'" with "lfdateCached:\'short\'", after that you will see all the date columns show the full date and time as following:

1 0

Replies

replied on March 8, 2021

The date columns in the tasks list do have consistent formats, the rule for the formats is:

when the date time is today, show time only, e.g. 8:50 AM
when the date time is within this year and not today, show month and date, e.g. Aug 11(due date will time as well)
when the date time is not in this year, show full date, e.g. 9/17/2022((due date will time as well)

When you hover the value, it will show the full date and time as "9/17/2021 2:10 PM".

Do you want to make all the date columns to show "9/17/2021 2:10 PM" always no matter what value of the date time?

0 0

replied on March 18, 2021

@Xiuhong Xiang is this something you are able to provide direction on?

"Do you want to make all the date columns to show "9/17/2021 2:10 PM" always no matter what value of the date time?"

0 0

SELECTED ANSWER

replied on March 19, 2021

The workaround you can use is following:

1 0

replied on March 19, 2021

Thank you!

0 0

replied on March 9, 2021

I understand that rule perfectly, but the client would like consistency. So yes, we want to change it so all the columns always show the full date. If this means including the time I'm sure they would be okay with it, as long as it's consistent.

0 0

You are not allowed to follow up in this post.

Question

Question

Forms date format issue

Answer

Replies

Sign in to reply to this post.