topic How to handle different timezones automatically in QlikView https://community.qlik.com/t5/QlikView/How-to-handle-different-timezones-automatically/m-p/687495#M249083 <HTML><HEAD></HEAD><BODY><P><BR />Hello All,</P><P></P><P>How a qlikview application created in one timezone will be automatically adjusting with different timezones including daylight saving.</P><P></P><P>We have below scenario:</P><P></P><P>We have some orders, if that remains unfulfilled within 24 hours, that should be automatically deleted from the system. I used sysdate to calculate it. But the orders can from any part of the world, so sysdate is not working here.</P><P></P><P>If you have any idea, then please help me urgently.</P><P></P><P>Thanks and Regards,</P><P>Nita Prasad</P></BODY></HTML> Fri, 15 Aug 2014 11:31:08 GMT Anonymous 2014-08-15T11:31:08Z How to handle different timezones automatically https://community.qlik.com/t5/QlikView/How-to-handle-different-timezones-automatically/m-p/687495#M249083 <HTML><HEAD></HEAD><BODY><P><BR />Hello All,</P><P></P><P>How a qlikview application created in one timezone will be automatically adjusting with different timezones including daylight saving.</P><P></P><P>We have below scenario:</P><P></P><P>We have some orders, if that remains unfulfilled within 24 hours, that should be automatically deleted from the system. I used sysdate to calculate it. But the orders can from any part of the world, so sysdate is not working here.</P><P></P><P>If you have any idea, then please help me urgently.</P><P></P><P>Thanks and Regards,</P><P>Nita Prasad</P></BODY></HTML> Fri, 15 Aug 2014 11:31:08 GMT https://community.qlik.com/t5/QlikView/How-to-handle-different-timezones-automatically/m-p/687495#M249083 Anonymous 2014-08-15T11:31:08Z Re: How to handle different timezones automatically https://community.qlik.com/t5/QlikView/How-to-handle-different-timezones-automatically/m-p/687496#M249084 <HTML><HEAD></HEAD><BODY><P class="syntax"><A name="kanchor475"></A><A name="LocalTime"></A><SPAN class="Bold"></SPAN></P><P class="syntax"><SPAN class="Bold">LocalTime(</SPAN><SPAN class="Italic">[timezone [, ignoreDST ]]</SPAN><SPAN class="Bold">)</SPAN> </P><P class="syntax"></P><P>Returns a <SPAN class="Italic">timestamp</SPAN> of the current time from the system clock for a specified time zone. The <SPAN class="Italic">timezone</SPAN> is specified as a string containing any of the geographical places listed under <SPAN class="Bold">Time Zone</SPAN> in the <SPAN class="Bold">Windows Control Panel</SPAN> for <SPAN class="Bold">Date and Time</SPAN> or as a string in the form 'GMT+hh:mm' or 'UTC+hh:mm'. If no timezone is specified the local time will be returned. If <SPAN class="Italic">ignoreDST</SPAN> is -1 (true) daylight savings time will be ignored. </P><P class="example">Examples:</P><P class="Code"><CODE>localtime ('Paris')</CODE> </P><P class="Code"><CODE>localtime ('GMT+01:00')</CODE> </P><P class="Code"><CODE>localtime ('Paris',-1)</CODE> </P><P class="Code"><CODE>localtime()</CODE></P></BODY></HTML> Fri, 15 Aug 2014 11:33:08 GMT https://community.qlik.com/t5/QlikView/How-to-handle-different-timezones-automatically/m-p/687496#M249084 MK_QSL 2014-08-15T11:33:08Z