Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › SecurityAssist › WA Rule Manager or Server Behaviour?

WA Rule Manager or Server Behaviour?

Thread began 1/31/2011 2:21 pm by Paul | Last modified 2/15/2011 3:02 pm by Paul | 1697 views | 6 replies

2/01/2011 2:59 pmJason ByrnesWebAssist

it is sorting the dates in exactly the way you have specified, in descending order:
30/1/2011
29/1/2011
2/2/2011
01/02/2011

bear in mind that MySQL is seeing a literal string:
2/2/2011

and not February Second 2011 you would need to use the Data Form at function to get the order to work the way you intend:
date-and-time-functions.html#function_date-format

maybe try:
ORDER BY DATE_FORMAT(j_on, '%c/%e/%Y') DESC

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.