I have a lookup column in multiple lists that points to a list of dates. These dates go in ascending order, and since the list posts are sequential, the older dates start to become irrelavent, forcing users that add new list items to scroll through to the bottom of the drop-down box to select the lastest date.

As you can tell this can be very tedious, all I need is for the lookup column to sort by DESCENDING order, and I've tried fooling with the lookup list's view, but I think it disregards the view and only looks at the list items.

Any thoughts?

1 Answer 1


Could you not do this using jQuery? I also thought you could set up a separate view of the list that has the dates and just use the date field and set its sort order and then use that view for the lookup.

  • I could possibly use jQuery, you tell me. I'm not an expert in jQuery. This is for the NewForm.aspx page for the List library. Also, the view cannot be changed from the NewForm.
    – Mike
    Commented May 24, 2010 at 21:28
  • I think that jQuery can get this done. Here is an example I found on the web. rickyrosario.com/blog/… Commented May 24, 2010 at 23:28
  • glad it helped! Commented Jun 23, 2010 at 21:17
  • Hey, could you post your sharepoint-adapted solution, please?
    – bgmCoder
    Commented Aug 2, 2013 at 21:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.