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?


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 May 24 '10 at 21:28
  • I think that jQuery can get this done. Here is an example I found on the web. rickyrosario.com/blog/… – spevilgenius May 24 '10 at 23:28
  • glad it helped! – spevilgenius Jun 23 '10 at 21:17
  • Hey, could you post your sharepoint-adapted solution, please? – bgmCoder Aug 2 '13 at 21:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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