topic Re: Timestamp Problem in QlikView

Timestamp Problem

perumal_41 — Sat, 05 Oct 2013 05:22:25 GMT

Hi,

I am

facing problem Calculating No of Days , when will minus Date filed -TimeStamp Field coming is Negative Value.

Date Field Value "21/08/0213" - convert to Num is Value "-615930"

Timestamp Field Value "17/08/2013 10:39:18 AM" convert to Num is Value "41503.443958333"

How slove this problem ,please guide me.

Re: Timestamp Problem

Sat, 05 Oct 2013 11:05:17 GMT

If you have a timestamp and you want a date, you should probably use a rounding function, e.g. Date(Floor(Timestamp#(DateTimeField, 'YYYYMMDD hh:mm:ss')), 'M/D/YY').

hope this helps

if yes mark this question as answered

Re: Timestamp Problem

swuehl — Sat, 05 Oct 2013 11:59:27 GMT

Your first date "21/08/0213" is in the 3rd century, I assume you want to use "21/08/2013".

If you really want to use a date in year 213 (I won't assume that QV calendar functions return the correct weekday etc. then ), your difference is indeed negative, because you need to go back in time to end with "21/08/0213"