Convert Dates in set analysis

[anuradhaa]

Hi,

I want to get the date based on selection criteria,

so i want to get Max date based on select criteria,

i used below syntax

=($(=Max(OutDate)))

but it return numaric value like 0.00074441687344913

but i want it as 3/2/2015. please tell me how to do that.

[#2]

date(($(=Max(OutDate))),'DD/MM/YYYY') or change the Number format to Date in the Properties

[jagan]

Hi,

I think it should return a date somewhere around 40000, not sure why you are getting this number, anyway try this

=Date(Max(OutDate), 'M/D/YYYY')

Hope this helps you.

Regards,

Jagan.

[#4]

hi,

use   Date(Max(OutDate), 'DD/MM/YYYY')

if its not giving date then send your date sample . something is wrong.

may be your OutDate is in text format so that max is not working properly.

Regards

Vimlesh