Need to sort datetime field array in ascending order

As 'yoga' mentioned...if the data is in a database you'd be better off using the SQL's 'ORDER BY' to apply the sort before retrieving into Appian.

In Appian you can use the 'sort' capability of a datasubset, something like this:

load(
  local!dataToSort: a!forEach(
    items: ri!dateTime,
    expression: {item: fv!item}
  ),
  fn!todatasubset(
    local!dataToSort,
    a!pagingInfo(
      startIndex: 1,
      batchSize: -1,
      sort: a!sortInfo(
        field: "item",
        ascending: true
      )
    )
  ).data.item
)

As 'yoga' mentioned...if the data is in a database you'd be better off using the SQL's 'ORDER BY' to apply the sort before retrieving into Appian.

In Appian you can use the 'sort' capability of a datasubset, something like this:

load(
  local!dataToSort: a!forEach(
    items: ri!dateTime,
    expression: {item: fv!item}
  ),
  fn!todatasubset(
    local!dataToSort,
    a!pagingInfo(
      startIndex: 1,
      batchSize: -1,
      sort: a!sortInfo(
        field: "item",
        ascending: true
      )
    )
  ).data.item
)