This project is in MOSS, using jQuery 1.6.1.
The basics of what I need: When the user filters on a date field, the value of the filter option needs to be "yyyy-M-d" while the text is "M/d/yyyy."
Reason: When the list is filtered, the page is reloaded and the querystring is appended with the &FilterField1=MyColumn&FilterValue1=03%2f07%2f2012. Code that I can't touch is then using the querystring to export the list with the filter in place and is choking on the %2f in the date.
Manually changing the querystring to ...FilterValue1=2012-03-07 allows the page filter to still work AND the export module doesn't barf on it.
Approaches:
- Is there a way to make SP use yyyy-M-d for the value and M/d/yyyy for the text? (I don't think so, because it appears to build the list from retrieved data which only include the M/d/yyyy text. I would be happy to be proved wrong, though.)
- Since I don't know of a way to do #1, I'm trying to manipulate it with jQuery... but the timing is kicking me hard: the filter select isn't loaded until the user clicks the filter/sort dropdown arrow; and then it's built in a separate page (/_layouts/filter.aspx) and displayed in an iFrame.
- I don't really want to go this route, because it will require a lot of overhead to duplicate existing functionality, but I suppose I could override the default behavior for my date fields and load them myself with SPServices, so that I could set the value and text as I see fit.
What suggestions have ye, oh wise ones?
Blessings, Jim Bob