Grid with Date and Time as column. Getting error message when click sort if C=couple of rows has no data for the date and time column

@vijayanv , This is expected as you have some null values. Appian treats null values as Text.
I would suggest to use todatetime() with apply() and try. This would help you

Yes ramanjaneyulut is right, you have to use todate() or todatetime() function to make data in consistent type

Hi vijayanv i believe, if there are any chances for being the Date Updated field as Empty/null, in such case you can go for any one of following approaches for Sorting:

1. You can disable the sorting for Date updated specific column as follows: a!gridTextColumn(field: {})
2. In case if you don't want to disable the column sorting, you can define some other column as the sorting for this such as:
a!gridTextColumn(field: "yourPKId/anyOtherField")

I hope any one of the way may suit your requirement.

Can we perform sorting for each column in each page ?I have a paging grid  of batch size 10 and I have a requirement to perform sorting on all columns per each page data , currently when I click on up or don arrow data is getting sorted for all pages . but I need sorting for each page

and what is the default sorting of appian (i.e. - Arrow up sort the column at ascending order
- Arrow down sort the column at descending order) is this right ?