Skip to main content
divyak0006
New Participant
Dec 17, 2025 11:11 AM UTC
Solved

Figure out the least date from the list

Hi Everyone,

Thanks in advance,

I have list which is having list of dates {1/1/2026; 2/2/2026; 12/31/2025; 11/24/2025}.I needs to identify the least date and Maximum date from the list.

Regards

Divya K

vijaym702296
vijaym702296Answer
New Participant
Dec 17, 2025 11:58 AM UTC

This will help you:- 

a!localVariables(
/* Your list of dates */
local!dateList: {
date(2026, 1, 1),
date(2026, 2, 2),
date(2025, 12, 31),
date(2025, 11, 24)
},

/* Find minimum (earliest) date */
local!minDate: min(local!dateList),

/* Find maximum (latest) date */
local!maxDate: max(local!dateList),

/* Display results */
{
minDateFormatted: text(local!minDate, "YYYY/MM/DD"),
maxDateFormatted: text(local!maxDate, "YYYY/MM/DD")
}
)

View in thread

3 replies

vijaym702296
vijaym702296Answer
New Participant
Dec 17, 2025 11:58 AM UTC

This will help you:- 

a!localVariables(
/* Your list of dates */
local!dateList: {
date(2026, 1, 1),
date(2026, 2, 2),
date(2025, 12, 31),
date(2025, 11, 24)
},

/* Find minimum (earliest) date */
local!minDate: min(local!dateList),

/* Find maximum (latest) date */
local!maxDate: max(local!dateList),

/* Display results */
{
minDateFormatted: text(local!minDate, "YYYY/MM/DD"),
maxDateFormatted: text(local!maxDate, "YYYY/MM/DD")
}
)

    shubhama926776
    shubhama926776
    Brainy
    Dec 17, 2025 1:03 PM UTC

    Have a look at it.

    a!localVariables(
  local!dates: {
    date(2026, 1, 1),
    date(2026, 2, 2),
    date(2025, 12, 31),
    date(2025, 11, 24)
  },
  {
    minDate: todate(min(local!dates)),
    maxDate: todate(max(local!dates))
  }
)

    शुभम्
      divyak0006Author
      New Participant
      Dec 18, 2025 9:38 AM UTC

      Thank you I tried the same approach it helped me out

      Terms & ConditionsAccessibility statement