11 Replies Latest reply: Oct 16, 2017 8:54 PM by Anil Babu RSS

    edit number format valueloop

    Lluis Cierco

      Hi all,

       

      I want to create a custom dimension with valueloop. This dimension is:


      =ValueLoop(today()-7,today(),1)

      This gives the 7 last days in number format.

      But I need to edit the number format of this dimension so it is a date (DD/MM/YYYY).

      I have allready tried =Date(ValueLoop(today()-7,today(),1), 'DD/MM/YYYY') and it doesn't work.


      Thanks