how do you get dates to appear in date format rather than number using class function

[#1]

I have successfully used the class function to give me the number or orders within date brackets but the problem i have is that the dates are showing up in the number format so my table looks like this:

40268<number or orders< 40270

40270<number of orders<40272

This isn't very easy for the end user to see the dates how do i get QLikView to show the dates in DD.MM.YY format?

The calculated dimension i have used is below

=class(DateCompleted,vWidth,'Number of Orders')

Thanks

[tresesco]

Hi,

Use ............. Date( DateValueField, 'DD-MM-YY' ) as Date...

Regards,

tresesco

[#3]

Do i put this in the calculated dimension?

My dimension now looks like this:

=class(Date(DateCompleted,'DD-MM-YY'),vWidth,'Purchase Size')

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?

[tresesco]

Hi,

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.

Regards,

tresesco