ConvertToLocalTime returns different results in QV12

[coengiesberts]

Hi,

I have recently moved from QV11 to QV12.20 (Nov 2017) and I noticed that ConvertToLocalTime() returns a different date. In case of dates that are in the summer time timeframe, the field Start_datum is one day behind. 

	LOAD delegation_id as %KEY_Delegatie, 
	     user_id, 
	     replacing_user_id, 
	     start_time,
	     date(floor(ConvertToLocalTime(TimeStamp(Makedate(1970,1,1)+ (start_time) /24/60/60),'GMT+01:00'))) as Start_datum,
	     date(floor(ConvertToLocalTime(TimeStamp(Makedate(1970,1,1)+ (end_time) /24/60/60),'GMT+01:00'))) as Eind_datum
	FROM [delegations.qvd] 	(qvd);

As an example, starttime 1555106400 returns 13/4/2019 in QV11 and 12/4/2019 in QV12.

If I try in Qlik Sense (Feb 2019), the same happens.

What can I do to get the correct results?

[Brett_Bleess]

I suspect the answer lies in the Release Notes for the 12.30/November 2018 release under Known issues and limitations section, here is a direct link to that document:

https://da3hntz84uekx.cloudfront.net/qlikview/12.30/123020000/QlikView%20November%202018%20Release%2...

That section is toward the end of the document, just FYI.  Hopefully this gets you the information you need.

Regards,
Brett