Skip to main content
Topic: Sort %added% descending (Read 273 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
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 :))

 
SimplePortal 1.0.0 RC1 © 2008-2019