topic converttolocaltime() in QlikView https://community.qlik.com/t5/QlikView/converttolocaltime/m-p/193092#M54507 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>I have enries in my database as</P><P>Region Loaded_Dt</P><P>Houston 09/17/2009 15:00:00</P><P>Europe 09/17/2009 14:00:00</P><P>Singapore 09/17/2009 11:00:00</P><P>Dubai 09/17/2009 12:00:00</P><P></P><P>All these time stamps are local time zone timestamps.</P><P>What I need to create in a report is show Number of loads today</P><P>In this case it should be 1 load for each region for 09/17/2009</P><P>How do I adjust my expression for showing this as loaded for 24 hrs period (per region)</P><P>Can I use daynumberofyear(converttolocaltime(Today()) ) = daynumberofyear(loaded_dt)</P><P>and it will automatically adjust to 24 hour period match for that particular region where the report is opened?</P><P></P><P>i.e if i open the report in dubai does converttolocaltime() mean 24 hours for that particular region - does the report adjust this expression based on where it is opened?</P><P></P><P>Thanks for the help.</P><P></P></BODY></HTML> Tue, 22 Sep 2009 02:14:59 GMT 2009-09-22T02:14:59Z converttolocaltime() https://community.qlik.com/t5/QlikView/converttolocaltime/m-p/193092#M54507 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>I have enries in my database as</P><P>Region Loaded_Dt</P><P>Houston 09/17/2009 15:00:00</P><P>Europe 09/17/2009 14:00:00</P><P>Singapore 09/17/2009 11:00:00</P><P>Dubai 09/17/2009 12:00:00</P><P></P><P>All these time stamps are local time zone timestamps.</P><P>What I need to create in a report is show Number of loads today</P><P>In this case it should be 1 load for each region for 09/17/2009</P><P>How do I adjust my expression for showing this as loaded for 24 hrs period (per region)</P><P>Can I use daynumberofyear(converttolocaltime(Today()) ) = daynumberofyear(loaded_dt)</P><P>and it will automatically adjust to 24 hour period match for that particular region where the report is opened?</P><P></P><P>i.e if i open the report in dubai does converttolocaltime() mean 24 hours for that particular region - does the report adjust this expression based on where it is opened?</P><P></P><P>Thanks for the help.</P><P></P></BODY></HTML> Tue, 22 Sep 2009 02:14:59 GMT https://community.qlik.com/t5/QlikView/converttolocaltime/m-p/193092#M54507 2009-09-22T02:14:59Z