topic Time field incorrect from Database during British Summer Time in QlikView https://community.qlik.com/t5/QlikView/Time-field-incorrect-from-Database-during-British-Summer-Time/m-p/405357#M491750 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have just noticed that my database does not increment the time forward one hour to compensate for British Summer Time (The clocks going forward one hour).</P><P>On one of the fields called <STRONG>logdate </STRONG>my values shows as: </P><P></P><P>23/03/2012 13:17:00</P><P>26/03/2012 13:17:00</P><P></P><P>However as the clocks went forward an hour on the 24/03/2012, the true value of the field should be:</P><P></P><P>23/03/2012 13:17:00</P><P>26/03/2012 14:17:00</P><P></P><P>Is there anyway that this can be changed in Qlikview, also if it can be changed in clickview, is there a way it can calcuate based on system time, therefore I wont have to write expressioned that include the clocks going forward and back for the next day 50n years <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>Regards,</P><P></P><P>Jon</P></BODY></HTML> Thu, 13 Sep 2012 14:40:54 GMT 2012-09-13T14:40:54Z Time field incorrect from Database during British Summer Time https://community.qlik.com/t5/QlikView/Time-field-incorrect-from-Database-during-British-Summer-Time/m-p/405357#M491750 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have just noticed that my database does not increment the time forward one hour to compensate for British Summer Time (The clocks going forward one hour).</P><P>On one of the fields called <STRONG>logdate </STRONG>my values shows as: </P><P></P><P>23/03/2012 13:17:00</P><P>26/03/2012 13:17:00</P><P></P><P>However as the clocks went forward an hour on the 24/03/2012, the true value of the field should be:</P><P></P><P>23/03/2012 13:17:00</P><P>26/03/2012 14:17:00</P><P></P><P>Is there anyway that this can be changed in Qlikview, also if it can be changed in clickview, is there a way it can calcuate based on system time, therefore I wont have to write expressioned that include the clocks going forward and back for the next day 50n years <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>Regards,</P><P></P><P>Jon</P></BODY></HTML> Thu, 13 Sep 2012 14:40:54 GMT https://community.qlik.com/t5/QlikView/Time-field-incorrect-from-Database-during-British-Summer-Time/m-p/405357#M491750 2012-09-13T14:40:54Z Re: Time field incorrect from Database during British Summer Time https://community.qlik.com/t5/QlikView/Time-field-incorrect-from-Database-during-British-Summer-Time/m-p/405358#M491751 <HTML><HEAD></HEAD><BODY><P>Ignore this one, I have figured it out.</P><P></P><P>You need to use the ConvertToLocalTime expression.</P></BODY></HTML> Thu, 13 Sep 2012 14:56:41 GMT https://community.qlik.com/t5/QlikView/Time-field-incorrect-from-Database-during-British-Summer-Time/m-p/405358#M491751 2012-09-13T14:56:41Z