topic Re: time stamp to date format in QlikView

time stamp to date format

Wed, 26 Nov 2014 06:08:10 GMT

Hi,

I have time stamp as a data type in data base. No i want to convert it to date format in Qlikview,if i use date or date# functions in qlikview its showing correct date format.

But when i use that in link table it is not filtering the dates when i select months.

can anyone help me in this...

Re: time stamp to date format

ashfaq_haseeb — Wed, 26 Nov 2014 06:10:21 GMT

Hi,

Try like below

Load

F1,

DATE_TIME,

Date(floor(DATE_TIME)) as Date

F3;

sql select * from table;

Regards

ASHFAQ

Re: time stamp to date format

tresB — Wed, 26 Nov 2014 06:12:39 GMT

Check if the db dates have the fractional values as well( for time), if so, try using floor() to truncate the fractional part of it, like:

Load

Date(Floor(DateFromDB)) as Date

Re: time stamp to date format

Wed, 26 Nov 2014 06:22:57 GMT

thanks for the reply..

it is converting into the date but when i use this in link table its not working

Re: time stamp to date format

aveeeeeee7en — Wed, 26 Nov 2014 06:24:51 GMT

Try this

Date(Subfield(Num(YourDateField),'.',1),'DD/MM/YYYY') AS NewDateField

Use Date Format which you want to use.

Hope that works for you.

Regards

Av7eN

Re: time stamp to date format

PrashantSangle — Wed, 26 Nov 2014 06:26:25 GMT

Hi,

Can you explain little bit more.

Regards

Re: time stamp to date format

ashfaq_haseeb — Wed, 26 Nov 2014 06:31:06 GMT

Hi,

Can you post sample app?

Regards

ASHFAQ