topic Re: What is the difference between Inyear and Inyeartodate. in QlikView https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Inyear-and-Inyeartodate/m-p/57904#M781558 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please see: <A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyear.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyear.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyear.htm</A></P><P></P><P>and </P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyeartodate.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyeartodate.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyeartodate.htm</A></P></BODY></HTML> Thu, 05 Apr 2018 05:41:47 GMT Anonymous 2018-04-05T05:41:47Z What is the difference between Inyear and Inyeartodate. https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Inyear-and-Inyeartodate/m-p/57901#M781555 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Inyear-and-Inyeartodate/m-p/57901#M781555 retko1985 2020-11-25T16:16:04Z Re: What is the difference between Inyear and Inyeartodate. https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Inyear-and-Inyeartodate/m-p/57902#M781556 <HTML><HEAD></HEAD><BODY><P>Try these two expression</P><P></P><P><STRONG>=InYear(MakeDate(2018, 12, 31), Today(),0)</STRONG></P><P><STRONG>=InYearToDate(MakeDate(2018, 12, 31), Today(),0)</STRONG></P><P></P><P>Since, 31st Dec 2018 is in 2018, it will show as -1 (TRUE) for InYear, but it is not between year start and today, it will show 0 for InYearToDate</P></BODY></HTML> Wed, 04 Apr 2018 19:19:13 GMT https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Inyear-and-Inyeartodate/m-p/57902#M781556 sunny_talwar 2018-04-04T19:19:13Z Re: What is the difference between Inyear and Inyeartodate. https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Inyear-and-Inyeartodate/m-p/57903#M781557 <HTML><HEAD></HEAD><BODY><P>Tomorrow is true for InYear, but not for InYearToDate.&nbsp; Likewise, Today() is true for both.</P></BODY></HTML> Wed, 04 Apr 2018 23:12:03 GMT https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Inyear-and-Inyeartodate/m-p/57903#M781557 jolivares 2018-04-04T23:12:03Z Re: What is the difference between Inyear and Inyeartodate. https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Inyear-and-Inyeartodate/m-p/57904#M781558 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please see: <A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyear.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyear.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyear.htm</A></P><P></P><P>and </P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyeartodate.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyeartodate.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/inyeartodate.htm</A></P></BODY></HTML> Thu, 05 Apr 2018 05:41:47 GMT https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Inyear-and-Inyeartodate/m-p/57904#M781558 Anonymous 2018-04-05T05:41:47Z