Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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:
That section is toward the end of the document, just FYI. Hopefully this gets you the information you need.
Regards,
Brett