Skip to main content ↑ ↓

Notice

Please note that most of the software linked on this forum is likely to be safe to use. If you are unsure, feel free to ask in the relevant topics, or send a private message to an administrator or moderator. To help curb the problems of false positives, or in the event that you do find actual malware, you can contribute through the article linked here.
Topic: Sort %added% descending (Read 1586 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Sort %added% descending

I want to sort %added% in descending order. %added% looks like this: 2019-06-19 22:15:14

I have tried
Code: [Select]
SORT DESCENDING BY %added%
but that doesn't seem to do anything. Is there another way to do this?

Re: Sort %added% descending

Reply #1 –
where? how?
 

Re: Sort %added% descending

Reply #3 –
Probably it doesn't support query syntax, but only titleformatting?
You can try this (untested):

Code: [Select]
$sub(9999,$year(%added%))-$sub(99,$month(%added%))-$sub(99,$day_of_month(%added%)) $sub(99,$substr(%added%,12,13)):$sub(99,$substr(%added%,15,16)):$sub(99,$substr(%added%,18,19))

Re: Sort %added% descending

Reply #4 –
Quote from: lvqcl on
Probably it doesn't support query syntax, but only titleformatting?
You can try this (untested):

Code: [Select]
$sub(9999,$year(%added%))-$sub(99,$month(%added%))-$sub(99,$day_of_month(%added%)) $sub(99,$substr(%added%,12,13)):$sub(99,$substr(%added%,15,16)):$sub(99,$substr(%added%,18,19))

Worked like a charm, a gold star for you sir :))