date without timestamp

R

r.vasikaran

Hi,

I have column having date and timestamp together, all i want is t
remove the time stamp.. i want only date has to be displayed.. i can d
that in format section, but on doing , in display i can see only date
but on the top i can see the timestamp along with the date..

pls help.

many thanks.
Vasikara
 
R

r.vasikaran

i got the answer..

actually we need to use as =int(cell no)

this will truncate the timestamp from the date format


thank
 
Top