Timestamp Problem

[perumal_41]

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.

[#2]

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

[swuehl · Accepted solution]

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"