Newbies willitho Posted November 20, 2009 Newbies Posted November 20, 2009 When I sort a list of dates, fields with dates are at the bottom of the list, behind all the records where the date field is empty. Is there a way to sort a list so that the empty fields appear at the end of the sorted list rather than at the top??
comment Posted November 20, 2009 Posted November 20, 2009 You could define a calculation field = Case ( Datefield ; Datefield ; Date ( 12 ; 31 ; 4000 ) ) and sort by it instead of by Datefield.
Recommended Posts
This topic is 5481 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now