[Bug]-[77]:Dissalowed Value DD.MM.YYYY in the Display Date Format Property of a Column in the Table Widget

[ame-appsmith]

Is there an existing issue for this?

• I have searched the existing issues

Description

A user is trying to use DD.MM.YYYY in the Display Date Format property of a table column, but it returns an error: Dissalowed value.

https://community.appsmith.com/t/cannot-set-dd-mm-yyyy-date-format-for-table-column/1694

Steps To Reproduce

1. Add a Table widget to the canvas and bind it to some data (e.g., the users sample database).
2. Try to change the format of a date column to DD.MM.YYYY in the Display Date Format property.

Public Sample App

No response

Issue video log

No response

Version

Appsmith v1.8.10-SNAPSHOT

Front conversations

[dilippitchika]

Assuming 10% of date users face this

Stats

Stat	Values
Reach	77
Effort (months)	0.5

[dilippitchika]

@vsvamsi1 please check this as well

[vsvamsi1]

@dilippitchika These are the formats we can support
"YYYY-MM-DDTHH:mm:ss.SSSZ", "Epoch", "Milliseconds", "YYYY-MM-DD", "YYYY-MM-DD HH:mm", "YYYY-MM-DDTHH:mm:ss.sssZ", "YYYY-MM-DDTHH:mm:ss", "YYYY-MM-DD hh:mm:ss", "Do MMM YYYY", "DD/MM/YYYY", "DD/MM/YYYY HH:mm", "LLL", "LL", "D MMMM, YYYY", "H:mm A D MMMM, YYYY", "MM-DD-YYYY", "DD-MM-YYYY", "MM/DD/YYYY", "DD/MM/YYYY", "DD/MM/YY", "MM/DD/YY",
can the user use either of thse format
"DD/MM/YY","DD-MM-YYYY",

[dilippitchika]

@vsvamsi1 the same dd.mm.yyyy works in the datepicker widget but not here in the table, is there a reason?

[vsvamsi1]

Hi @dilippitchika, Its very strange on the DatePicker there are no restrictions on the allowed in the formats. You could enter a random incorrect format like in the screenshot and there is no error from our app. For the datePicker it attempts to format what it can infer, whereas in the Table we limit it to a list. Im not sure what is the right behaviour.

[dilippitchika]

If we are the ones limiting to a list in datepickers inside tables, why can't we add DD.MM.YYYY? Regardind datepicker widget not validating, please create a separate issue

[vsvamsi1]

Sure @dilippitchika will do that and these new formats we should support for Display date format and not Original Date format?

[dilippitchika]

We should support it for both i believe, display and original date

[ame-appsmith]

We have another user on Discord who is trying to set the date format programmatically. The formats are supported in a Date Picker widget, but not in the Table Date column.
Here are some examples of date formats that are disallowed in the Table column but supported in the Date Picker widget:

• DD/MM/YYYY hh:mm:ss A
• DD.MM.YYYY HH:mm:ss A
• MM/DD/YYYY hh:mm:ss A

[ame-appsmith]

Another user raised the same issue on Discord.

[Nikhil-Nandagopal]

@ame-appsmith a workaround for this is to update the computed value and format it using moment