Order by Dates - Blanks coming first [message #392791] |
Thu, 19 March 2009 05:23  |
velnias2008
Messages: 3 Registered: March 2009
|
Junior Member |
|
|
Hey All,
I 2 columns Date Added and Date Updated
I am trying to sort my table by date updated.
Not all records will have date updated date, when I am doing the sort the problem is the records with a blank are coming in first then my date updated ones sorted come through.
How can I get the sort to work with most upto date dateupdated records first then the records with no date updated which are then sorted as normal by dateAdded.
Steven
|
|
|
|
|
|
Re: Order by Dates - Blanks coming first [message #392807 is a reply to message #392791] |
Thu, 19 March 2009 05:46   |
velnias2008
Messages: 3 Registered: March 2009
|
Junior Member |
|
|
Ye worked nicely thanks...
One thing I noticed though is that it sorts by dateUpdated fine but if there is a new record added which doesnt have a dateupdated date yet it doesnt go to the top of page but the first one below the last date updated even though that date is higher
|
|
|
|
Re: Order by Dates - Blanks coming first [message #392819 is a reply to message #392807] |
Thu, 19 March 2009 06:25  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
velnias2008 wrote on Thu, 19 March 2009 11:46 | Ye worked nicely thanks...
One thing I noticed though is that it sorts by dateUpdated fine but if there is a new record added which doesnt have a dateupdated date yet it doesnt go to the top of page but the first one below the last date updated even though that date is higher
|
Higher than what? You said the dateipdated is empty..
|
|
|