Universe Conditions to get the Latest date

[Former Member]

Dear all,

I have date filed in Universe- DATAB(field) name stroing the data like 01.01.2010, 02.03.2010,20.10.2011, need to write one logic to get the Latest Date (20.10.2011),please any one help me to get the correct SQL logic.

Regards,

Kavitha.

[Former Member]

Hi Kavitha

create a duplicate object

in that select filed add your dataB field and in where condition dataB=max(dataB)

Hope this helps u

Sunil

Edited by: K.sunil on Dec 6, 2011 8:10 AM

[Former Member]

Hi Kavitha,

Please use maxdate SQL function . what database using to your universe?

Thanks