time stamp to date format

[#1]

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...

[ashfaq_haseeb]

Hi,

Try like below

Load

F1,

DATE_TIME,

Date(floor(DATE_TIME)) as Date

F3;

sql select * from table;

Regards

ASHFAQ

[tresesco]

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

[#4]

Hi

thanks for the reply..

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

[aveeeeeee7en]

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

[PrashantSangle]

Hi,

Can you explain little bit more.

Regards

[ashfaq_haseeb]

Hi,

Can you post sample app?

Regards

ASHFAQ