Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I thought same, But before commit to others just to check from experts.Thanks Marcus
If it is chart, Then we can make. But, I am thinking from list box? As Andrew already stated we can go with that by using Custom format cell to remove the cell borders After/Before. Thanks Marco