edit number format valueloop

[Anonymous]

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

[Anil_Babu_Samineni]

I thought same, But before commit to others just to check from experts.Thanks Marcus

[Anil_Babu_Samineni]

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