8 Replies Latest reply: Jan 24, 2018 4:07 AM by Ruggero Piccoli RSS

    Nprinting Filter by the previous week

    Daniel Blois

      I have a field called [FISC Week #] and I need to filter my report by the previous week.  I am quite new.


      I have tried numerous ways? and it will not give me a value.


      =FirstSortedValue([Transaction Date] =  Date(Now()) - 7, [FISC Week Ending Date])


      =FirstSortedValue(Max([Transaction Date])-7, [FISC Week Ending Date])