Dell-User Preference updated with MM-dd-yyyy date format. Search critiera breadcrumb doesnt reflect that format and datefilter not working

[raniangamuthu]

Login>update the date preference to be MM-dd-yyyy Search Form > Enter the date criteria using the calendar and the date format displayed as set in user preference.>Execute search>Search result page the breadcrumb still shows in yyyy-MM-dd format. Also, the date filter is not working as expected. Attached screenshots below:

[kilam005]

This issue has been informed to team. Work is in progress.

[kilam005]

@raniangamuthu the changes are made and will be avaialble by tomorrow for deployment.

For Date format in breadcrumb Fix details the user preference was pushed to the breadcrumb area See references below

---

---

w.r.t Date filter not working RCA there was a code typo.

Fix details code typo was rectified. See references below

[raniangamuthu]

Additionally, the sorting is not working when the preference is changed.

[kilam005]

@raniangamuthu Please check of the result column's configuration is marked as date. This seems to be query formatted date column and result column is configured as string

[raniangamuthu]

you are right Malik but i am not able to cast the string say 01/01/2024 to date type, looks like Trino limitation. Need some guidance here

[kilam005]

@raniangamuthu

Can you give some clarity on the date column field and some sample data to understand the format.

• is the data type of the column a data or string or datetime
• if it's in string what is the format in which the data exist. (Ymd or mdy or something else)

Once I get these info, I can provide you query guidance

[kilam005]

For your specific question on how to cast mm/dd/yyyy date you can use the below

date_parse('01/01/2024', '%m/%d/%Y')

The above function will return a timestamp value 2024-01-01 00:00:00.000

Using

date(date_parse('01/01/2024', '%m/%d/%Y')) should get you result as date ie. 2024-01-01

Give this a try and let me know if you need more assistance.

[Udhayanila8]

Tested in 3.1.7 version also. Server : 192.168.56.172

Screenshots

[kilam005]

As discussed with @raniangamuthu , user perference translation to date fiedls was patched. Extedning option to allow format selection will be adoped in next version release

[Udhayanila8]

Tested in 2024.01.45313_P1 version in 146 server.

[kilam005]

@raniangamuthu the fix is available in Effectv environment. Please check and give closure