Thu, 24 Sep 2026
Login

how to sort date

Confluence User - 17 Sep, 2020

My datalist cannot sorting the date properly from the latest date.. 

How can I change the date format from string to date?

datalists;forms;sorting;date

3

Confluence User •
17 Sep, 2020 •
confluenceUser •
•
confluenceUser •

Store your dates as "yyyy-MM-dd" and the date sorting in datalist will now work correctly (year first, month, and day, all in numeric values, for example, "2020-12-31").

Confluence User •
18 Sep, 2020 •
confluenceUser •
•
confluenceUser •

If I have already entered all the data in the system, do I need to re-enter it again?

Confluence User •
18 Sep, 2020 •
confluenceUser •
•
confluenceUser •

This is a database solution and out of the scope of Joget:

Use a database utility such as SQLyog Community (for MySQL DB) and SQL update query with  the SUBSTRING() function to swap positions of the dd or MM or yyyy in your existing DB table.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print