SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 0 down vote accepted

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.

share|improve this answer
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.… – spevilgenius May 24 '10 at 23:28
that did it, thanks! – Mike Jun 23 '10 at 21:02
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 posting your answer, you agree to the privacy policy and terms of service.

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