When columns are added / edited in a custom submitted forms tab, they are set to display as text by default. This means when sorting by date, the forms will be listed in alphabetical or numerical value.
To change this, in the Web Portal go to Forms > Submitted Forms > select the New / Edit tab > select the tab you would like to edit.
1. Inside the editing screen, you will first need to add a New Column, and select the date field that can be found in the Submitted Form (form fields that you can select from will be listed at the bottom of the dropdown here, under Custom Fields). In this example, the custom form field is called 'Date Requested'.
2. Next, you will need to create the Custom Heading Name to link the column to. Select New Row and enter the column name you want to use.
3. After entering the name that you'd like it to be called, you can then also go to the the dropdown at the end of the field, and this is where you will select what kind of field it represents so that it will be treated as the right type of field when filtering / sorting forms in the custom tab. It is set as Text by Default, so you want to change this to Date.
4. Once that is done, you can match the Column Headings with the correct Form Fields, so that the column will retrieve the correct information. After that is done, you can Save.
After the Custom Submitted Form tab has edited, it will need to sort through all the forms that are related to it. While it's doing that sorting, the date field may come up as 1st Jan 1970. This will correct itself once the tab has finished sorting through the dates within the forms.
Related: