Hi,

I have a file like this

(ADD_MONTHS((Substr(Trim(BOTH FROM Translate(Maximum(closeDa
------------------------------------------------------------
2007-06-30 00:00:00

I have a requirement where i need just the date.

When i do: tail -1 filename|tr -s ""
my problem doesnot solve.I am getting leading spaces before the date.

I need an output like: 2007-06-30 00:00:00

Can anybody help me??

-- Mahek