0

I have two columns, a site complete column and a report complete column. I need a view to show all blanks in the report complete column if today is 30+ days past the site complete date. Everything I find on this uses [Today] to calculate, however that does not seem like it will work for what I am doing.

I tried [site complete]+30, and that does not seem to work.

3

In views, the [Today] column will work as a filter.

In your view you would have a compound filter:

Report Complete is equal to and leave the field blank.

And

Site Complete is greater than or equal to [Today]-30 

This is looking for blank report complete fields with the additional filter that the site complete is more than 30 days ago. Is that what you want?

  • But.. enter those formulas without spaces [Today] - 30 will fail [Today]-30 is fine – Danny '365CSI' Engelman Jan 23 '17 at 20:22
  • @Danny'365CSI'Engelman thanks, updated, should have known better – Eric Alexander Jan 23 '17 at 20:42
  • That is what I want, it just did not seem like it was what I needed it to be. Thank you – Cory Cox Jan 24 '17 at 13:19
  • Great, if this solves your problem, be sure to tick the check box to mark it as an answer. Welcome to sp.se! – Eric Alexander Jan 24 '17 at 14:26

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.