Sort column values (dates) by desc

[1600eads]

I am having issues doing the normal sorting desc. 

I have this date field, where the '-' is an actual value we need to display as this denotes that this user is in queue. When I try to sort by desc, I expected to see latest date values at the top but it is not changing accordingly. Any ideas on this behavior? 

[sbaro_bd]

Hi @1600eads ,

It's normal when you're applying a descending sort on a column with a symbol. Two solutions : 

• Clear all '-' symbols when you load your data.
• Or define this statement in your script SET NullInterpret = '-';.It will help you to interpret dash like a NULL value.

Try it and tell us if it works.

Regards.

[Chanty4u]

Try this 

LOAD 

    If([Date Field] = '-', Null(), Date#([Date Field], 'DD/MM/YYYY')) AS Date_Sorted,

    [Date Field];

Use this Date_Sorted field in your sorting options