topic Re: Diff. between dates is giving decimal value. in QlikView

Diff. between dates is giving decimal value.

markgraham123 — Thu, 11 Feb 2016 18:12:50 GMT

Hi all,

I have ID, Field1 (Date1) and Field2 (Date2).

When i try to do Field2-Field1, the result is in decimals.

I was wondering why, as i never faced this issue and the fields were in Date format but not Timestamp.

Can someone help. Pls find attachment.

Anonymous — Thu, 11 Feb 2016 18:22:23 GMT

Your fields are timestamps, so you need to floor() them by using an expression like this :

floor(Field2)-floor(Field1)

Clever_Anjos — Thu, 11 Feb 2016 18:25:50 GMT

Your Field1 is a timestamp formatted as date, please check your excel file

markgraham123 — Thu, 11 Feb 2016 18:28:04 GMT

Yes sir. But i have converted it to Date using Date(Filed1) and Date(Filed2) function.

markgraham123 — Thu, 11 Feb 2016 18:28:24 GMT

Is it because the timestamp still present?

Anonymous — Thu, 11 Feb 2016 18:34:04 GMT

Not in the load script of the qvw you posted :

Directory;

LOAD ID,

Field1,

Field2

FROM

tets.xlsx

(ooxml, embedded labels, table is Sheet1);

Anonymous — Thu, 11 Feb 2016 18:35:13 GMT

Also Date() just formats it, you need the floor() to remove the timestamp decimals.

markgraham123 — Thu, 11 Feb 2016 18:37:10 GMT

I got it now.

Thanq Bill

Clever_Anjos — Fri, 12 Feb 2016 15:29:47 GMT

Date() does not convert, only formats

Date(Floor()) does what you need