Time stamp to date conversion issue

[#1]

hi,

I have a date field in this format "DD/MM/YYYY hh:mm:ss AM" .now I need to extract only date from this filed.

when I am sing the date function to extract am getting Multiple values for same date since the Time is different for tht. How can I get distinct date in date field??

Kindly suggest!!...

Regards;

Reena

[amit_saini · Accepted solution]

Try this:

date(floor(MyTimeStampField), 'DD-MM-YYYY')

Thanks,
AS

[Anonymous]

use date(floor(time stamp)) while loading the date...

[PrashantSangle]

Hi,

USe floor() inside date()

try like

date(floor(datefield))

Regards

[#5]

yea...with floor it worked.. !!! Thanks a lot..

[amit_saini]

If it is working fine , please close the thread !

Thanks,
AS