Filtering rows in a slice and then sorting them

[Gerhard_Viljoen]

Hi guys,

I have been successful in slicing my data to produce a list of installation dates that are planned ahead and closer than 10 days in the future:

and(
[Planned Date] >= TODAY(),
[Planned Date] < (TODAY() + 10)
)

But now I would like to sort this result by the date column and the following doesn't work:

ORDERBY(
and(
[Planned Date] >= TODAY(),
[Planned Date] < (TODAY() + 10)
),
[Planned Date],
TRUE)

I need the list to show the results from earliest to latest date.

Any help would be appreciated. Thanks!