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