topic Re: Time stamp to date conversion issue in QlikView

Time stamp to date conversion issue

Thu, 16 Apr 2015 05:48:24 GMT

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

Re: Time stamp to date conversion issue

amit_saini — Thu, 16 Apr 2015 05:53:42 GMT

Try this:

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

Thanks,
AS

Re: Time stamp to date conversion issue

Anonymous — Thu, 16 Apr 2015 05:55:56 GMT

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

Re: Time stamp to date conversion issue

PrashantSangle — Thu, 16 Apr 2015 05:56:58 GMT

Hi,

USe floor() inside date()

try like

date(floor(datefield))

Regards

Re: Time stamp to date conversion issue

Thu, 16 Apr 2015 06:13:35 GMT

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

Re: Time stamp to date conversion issue

amit_saini — Thu, 16 Apr 2015 06:25:20 GMT

If it is working fine , please close the thread !

Thanks,
AS