How to change the date format (YYYY,MM,DD) to (DD,MM,YYYY) in the case fom.

[poornima batchu]

HI,

I created a date field in the hr case form but the default format is (YYYY, MM, DD) this I want to change the format of my field only to (DD,MM, YYYY).Please add the possible solutions to achieve this.

Thank you

[Community Alums]

Hi poornima,

Changing from basic configuration meaning that changing the sys_property (i.e. glide.sys.date_format)  and it will change for all users. 

Unfortunately I can't see any way to update from script or anything else.

Regards,

Akshay

[Alex Coope - SN]

@poornima batchu,

Date formats are an interesting one, because what you see (YYYY-MM-DD) could be a valid format to certain users in parts of the world vs what someone else sees in my part of the world (DD-MM-YYYY). With that being said, it is not advisable to either change the format on the field (at the dictionary level) or the system default level unless the norm for the Customer is that specific format.

Changing the system default value could also impact other scripts previously built if they are expecting a specific format, so it would require a thorough test to ensure it doesn't break anything else.

If the system default is changed, it will change for every Date and DateTime field across the platform, which may contradict with a user's specific preference. Therefore, it's generally considered best-practice to leave the back-end format as required for the business (all calculations are against that format) but all presentations are as a User feels is most comfortable for them,

So to recap, if it's purely for aesthetic reasons it's best to leave for the user-preference (either by letting them chose, or pre-setting on their behalf),

Many thanks,
Kind regards