I am building a SharePoint 2013 portal. I have a custom list. On this list I try to modify the default view. I would like to change the filter settings. I would like to show only the items between today and the last half jaar. How can I implement this? I know I can use the tag [TODAY]. But how do I calculate the date for 6 months back.enter image description here

1 Answer 1


Have you tried using [today]-180?

  • thanks this works. there is only one issue. A half year is not a fixed number of 180 days.
    – Ola
    May 2, 2014 at 12:21
  • I know, but as far as I know you can only use a fixed number of days.
    – yandr
    May 2, 2014 at 17:28

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.