I have a List web part that has a (hidden) date column. I've added a Date Filter web part and connected it to the list. The filter is working.

Setting the default to a calculated value doesn't seem to be an option in the edit menu.

How can I set the default value for a Filter to be a calculated value? For example, I have a formula to calculate the next upcoming Wednesday: =TODAY()+MOD(11-WEEKDAY(TODAY()),7)

But where do I put this formula? I want this to be the default value for the Date Filter.

I'm a SharePoint Noob so I apologize for not knowing the proper terms. I'ave added a picture to hopefully make it clearer:

enter image description here

  • can you explain bit more, so all can get clear picture – Gaurravs Oct 18 '15 at 5:59
  • I added a picture and hopefully better explanation – 43Tesseracts Oct 18 '15 at 6:25
  • Please correct me if I am wrong, Scenario is you have a date filter for which you need next Wednesday's date as default, which will fetch data from Event List. – Gaurravs Oct 18 '15 at 6:35
  • Yes, Exactly.... – 43Tesseracts Oct 18 '15 at 6:40
  • use jquery to set the date value for this control? – Gaurravs Oct 19 '15 at 14:29

Your Answer

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

Browse other questions tagged or ask your own question.