Both Qlikvew and SQl Server can store datetime ( datetime of sql server queals to timestamp of Qlikview) in float format. when change the datatype from float to datetime , there will be 2 days’ difference .
for example , in sql server , select CAST ( 40358 as datetime) returns 2010-07-01 00:00:000,
but in Qlikvew, expression timestamp( 40358) = 2010-06-29 12:00:000 am.
Qlikview gets he same result as what Excel gets
