compare list of dates to findout least date and max date logic

geervanim over 4 years ago

Hi Friends,

Can someone help me to find the least date and max date from a given list of dates.

Thanks

Vani

Discussion posts and replies are publicly visible

Top Replies

vimalkumars over 4 years ago +3
Certified Lead Developer

Hope the below expression gives some thoughts: with( local!dates: { today(), today() - 3, today() + 5, today() - 1 }, "Least date: " & todate( min( tointeger( local!dates ) )…

Parents

0 Stewart Burchell

Appian Employee

over 4 years ago

You can also use the sorting capability in a datasubset. Here's an example:

a!localVariables(
  local!listOfDates: {
    {id: 1, date: now()+1},
    {id: 2, date: now()+11},
    {id: 3, date: now()-2}
  },
  /*local!listOfDates.date*/
  local!sortedDates: fn!todatasubset(
    local!listOfDates,
    a!pagingInfo(
      startIndex: 1,
      batchSize: -1,
      sort: a!sortInfo(
        field: "date",
        ascending: false
      )
    )
  ),
  local!sortedDates.data
)

If you run this, and then change the 'ascending' attribute to 'true' and then run it again you'll see the order is reversed.

Reply

0 Stewart Burchell

Appian Employee

over 4 years ago

You can also use the sorting capability in a datasubset. Here's an example:

a!localVariables(
  local!listOfDates: {
    {id: 1, date: now()+1},
    {id: 2, date: now()+11},
    {id: 3, date: now()-2}
  },
  /*local!listOfDates.date*/
  local!sortedDates: fn!todatasubset(
    local!listOfDates,
    a!pagingInfo(
      startIndex: 1,
      batchSize: -1,
      sort: a!sortInfo(
        field: "date",
        ascending: false
      )
    )
  ),
  local!sortedDates.data
)

If you run this, and then change the 'ascending' attribute to 'true' and then run it again you'll see the order is reversed.

Children

No Data