Order a Select statement by date for display as Long Text

[simonhelps]

I have a select statement that pulls a list of expiry dates for individual products and displays as information to the user in long text format. My code works but it just shows the dates in order of their line entry in the spreadsheet but I would like it to sort the dates first to display with most recent dates first. Below is the code I use:-

text(
SELECT(
Drinks[Expiry Date],
and(
([EffectiveBarcode] = [_THISROW].[EffectiveBarcode]),
([Active] = TRUE)
)
,true)
)

This is how the data displays:-

This is the column setup:-

Many thanks

[TeeSee1 · Accepted solution]

Try

TEXT( SORT( SELECT(...), TRUE))

https://support.google.com/appsheet/answer/10107698?hl=en

[simonhelps]

Thanks! just had to change true to false to have the date expiry ascending.