topic Re: Date function is not working. in QlikView https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290905#M853530 <HTML><HEAD></HEAD><BODY><P>You need to give the right date format here</P></BODY></HTML> Thu, 16 Feb 2017 14:09:12 GMT sunny_talwar 2017-02-16T14:09:12Z Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290898#M853523 <HTML><HEAD></HEAD><BODY><P>Below expression in list box is not working.</P><P></P><P>=if(DATE([Expiration Date],'MM-DD-YYYY') &gt;'09-01-2016',[Expiration Date])</P><P></P><P>Not suure why</P><P></P><P></P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290898#M853523 apthansh 2020-11-25T16:16:04Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290899#M853524 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=if([Expiration Date] &gt; MakeDate(2016, 9, 1), [Expiration Date])</STRONG></SPAN></P></BODY></HTML> Thu, 16 Feb 2017 13:32:22 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290899#M853524 sunny_talwar 2017-02-16T13:32:22Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290900#M853525 <HTML><HEAD></HEAD><BODY><P>Is ur ([Expiration Date], a date .Add list box and see..If its falling ryt panel then yes..If at left pane then use first Date# and then proceed..</P><P></P><P>Sachin</P></BODY></HTML> Thu, 16 Feb 2017 13:33:12 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290900#M853525 sdmech81 2017-02-16T13:33:12Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290901#M853526 <HTML><HEAD></HEAD><BODY><P>upon cross verify,</P><P></P><P>Sunny's expression should work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Sachin</P></BODY></HTML> Thu, 16 Feb 2017 13:36:46 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290901#M853526 sdmech81 2017-02-16T13:36:46Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290902#M853527 <HTML><HEAD></HEAD><BODY><P>Thnak you sunnyy..That worked...</P><P>how can I put the same in sheet trigger ?</P></BODY></HTML> Thu, 16 Feb 2017 14:05:20 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290902#M853527 apthansh 2017-02-16T14:05:20Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290903#M853528 <HTML><HEAD></HEAD><BODY><P>I gave the below in select in field.Not working</P><P></P><P>='&gt;=' &amp; MakeDate(2016, 9, 1) </P></BODY></HTML> Thu, 16 Feb 2017 14:07:49 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290903#M853528 apthansh 2017-02-16T14:07:49Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290904#M853529 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P>Field</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[Expiration Date]</STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P><P>Search String</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">='&gt;=' &amp; Date(<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">MakeDate(2016, 9, 1)</STRONG>, '<SPAN style="color: #ff0000;">DateFieldFormatHere</SPAN>')</STRONG></P><P></P><P>Make sure to use the date field format of Expiration Date to replace <STRONG style="color: #ff0000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DateFieldFormatHere</STRONG></P></BODY></HTML> Thu, 16 Feb 2017 14:08:51 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290904#M853529 sunny_talwar 2017-02-16T14:08:51Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290905#M853530 <HTML><HEAD></HEAD><BODY><P>You need to give the right date format here</P></BODY></HTML> Thu, 16 Feb 2017 14:09:12 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290905#M853530 sunny_talwar 2017-02-16T14:09:12Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290906#M853531 <HTML><HEAD></HEAD><BODY><P>You are awesome....my hero <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 16 Feb 2017 14:11:54 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290906#M853531 apthansh 2017-02-16T14:11:54Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290907#M853532 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 16 Feb 2017 14:12:32 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290907#M853532 sunny_talwar 2017-02-16T14:12:32Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290908#M853533 <HTML><HEAD></HEAD><BODY><P>Sunny would have been flying if response was frm girl <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 16 Feb 2017 14:16:29 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290908#M853533 sdmech81 2017-02-16T14:16:29Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290909#M853534 <HTML><HEAD></HEAD><BODY><P>Sachin -</P><P></P><P>1) I am married <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>2) I value positive feedback from male or female</P></BODY></HTML> Thu, 16 Feb 2017 14:20:07 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290909#M853534 sunny_talwar 2017-02-16T14:20:07Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290910#M853535 <HTML><HEAD></HEAD><BODY><P>Kidding <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Nice to hear</P></BODY></HTML> Thu, 16 Feb 2017 14:23:48 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290910#M853535 sdmech81 2017-02-16T14:23:48Z Re: Date function is not working. https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290911#M853536 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 16 Feb 2017 14:26:34 GMT https://community.qlik.com/t5/QlikView/Date-function-is-not-working/m-p/1290911#M853536 apthansh 2017-02-16T14:26:34Z