4 Replies Latest reply: Nov 5, 2015 4:36 AM by Rudolf Linder RSS

    Formula in text box

    Darri Hilmarsson

      Hi, QV community


      I have one problem that needs solving.


      I have data for the sale of my company for every day.

      I wanted to make a big text box that says "Sales in  & last(YrWk)

      But my problem is of course that the date is always changing so I have to make a formula in my text box


      Let me explain this better:


      So today is the date 5.11.2015 so that makes it week 45 in the year 2015 or 2015-Wk45 in my data.

      So last week was 2015-Wk44.

      So I need a formula in the text box that says Sales in 2015-Wk44



      regards Darri