ConvertToLocalTime returns different results in QV12

coengiesberts — Sat, 16 Nov 2024 21:02:19 GMT

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?

Re: ConvertToLocalTime returns different results in QV12

Brett_Bleess — Wed, 29 May 2019 14:08:14 GMT

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%20Notes.pdf

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

Regards,
Brett

topic ConvertToLocalTime returns different results in QV12 in QlikView

ConvertToLocalTime returns different results in QV12

Re: ConvertToLocalTime returns different results in QV12