Do i put this in the calculated dimension?
My dimension now looks like this:
which doesn't work. In the load scipt the date pulls through in DD-MM-YY format but the class function automatically puts it in number format but i can't see how to change this.
Is there another function other than class that i could use?
If you have got the desired date range in a field (say-NumericDate) after applying Class function, then what you can do is, get the resident of that field(NumericDate) and apply the date function as i told earlier, i.e. Date(NumericDate,'DD-MM-YY') as FinalDate ..............in the SCRIPT.