topic Problem with date() in a if statement in QlikView https://community.qlik.com/t5/QlikView/Problem-with-date-in-a-if-statement/m-p/173091#M502596 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I defined a variable vHour with the actual hour</P><P>LET vHour = date(localtime(),'hh');</P><P>and now I wanted to test if vHour is 00</P><P>if vHour = '00' then ...</P><P>but it doesnt work. I also tested this:</P><P>if vHour = date(time('00:00:00'),'hh') then ...</P><P>Pleas help me</P><P>best regards</P><P>Ingo Placzek</P><P></P></BODY></HTML> Wed, 25 Aug 2010 06:39:00 GMT 2010-08-25T06:39:00Z Problem with date() in a if statement https://community.qlik.com/t5/QlikView/Problem-with-date-in-a-if-statement/m-p/173091#M502596 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I defined a variable vHour with the actual hour</P><P>LET vHour = date(localtime(),'hh');</P><P>and now I wanted to test if vHour is 00</P><P>if vHour = '00' then ...</P><P>but it doesnt work. I also tested this:</P><P>if vHour = date(time('00:00:00'),'hh') then ...</P><P>Pleas help me</P><P>best regards</P><P>Ingo Placzek</P><P></P></BODY></HTML> Wed, 25 Aug 2010 06:39:00 GMT https://community.qlik.com/t5/QlikView/Problem-with-date-in-a-if-statement/m-p/173091#M502596 2010-08-25T06:39:00Z Problem with date() in a if statement https://community.qlik.com/t5/QlikView/Problem-with-date-in-a-if-statement/m-p/173092#M502597 <HTML><HEAD></HEAD><BODY><P>Ingo</P><P>The Date function changes the text representation of the date value, but it returns the full date/time value (see 'dual' in the manual).</P><P>To get the time in hours, you could use <B>text(date(localtime(),'hh'))</B> or <B>round(frac(localtime())*24, 1)<BR /></B></P><P>Jonathan</P></BODY></HTML> Wed, 25 Aug 2010 07:23:05 GMT https://community.qlik.com/t5/QlikView/Problem-with-date-in-a-if-statement/m-p/173092#M502597 jonathandienst 2010-08-25T07:23:05Z Problem with date() in a if statement https://community.qlik.com/t5/QlikView/Problem-with-date-in-a-if-statement/m-p/173093#M502598 <HTML><HEAD></HEAD><BODY><P>thanks, it works <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Wed, 25 Aug 2010 08:58:53 GMT https://community.qlik.com/t5/QlikView/Problem-with-date-in-a-if-statement/m-p/173093#M502598 2010-08-25T08:58:53Z