0

I am trying to create a view where Invoice Admin wants to see all the records where invoice due dates are within next 5 days. I added a calculated column and i have =[DueDate]-5 but this formula only gives me the records that have a DueDate 5 days from now. Is there a way to get all the records that are due from today to 5 days from today?

2

You don't need a calculated column for this. Just use your existing [DueDate] column twice in your view filter:

Show the items when column
DueDate
is greater than or equal to
[Today]

and

when column
DueDate
is less than or equal to
[Today]+5

  • The list is huge. – Kevin Short Jun 25 '15 at 18:02
  • Did you perhaps set the filter to or instead of and? – Dan Henderson Jun 25 '15 at 18:53
  • 1
    And you can not do it with a Calculated Column, because the Formula is only updated when a List Item is changed. So you have to do it with the filter in a View as Dan Henderson explains. – Danny '365CSI' Engelman Jun 25 '15 at 20:06
0

Try creating a view with filter where due date is less than [Today] - 5

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.