topic Re: Current YTD Flag creation for an odd start and end date in QlikView https://community.qlik.com/t5/QlikView/Current-YTD-Flag-creation-for-an-odd-start-and-end-date/m-p/689#M793574 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny,</P><P></P><P>If(TempDate &gt;= (YearStart(Today(), 0, 8)) + 27 and TempDate &lt;= Today(), 1, 0) AS Flag</P><P></P><P>Works perfectly.</P></BODY></HTML> Mon, 15 Jan 2018 23:12:39 GMT ashleywooldridg 2018-01-15T23:12:39Z Current YTD Flag creation for an odd start and end date https://community.qlik.com/t5/QlikView/Current-YTD-Flag-creation-for-an-odd-start-and-end-date/m-p/687#M793572 <HTML><HEAD></HEAD><BODY><P>I am trying to get a current year to date flag set-up for a Master Calendar.</P><P></P><P>The issue I have is that the start date for the trade year is 28th August.</P><P></P><P>I cannot seem to find anything that will allow me to have the 28th August as the start day for the current YTD.</P><P></P><P>Is there a way I can define the 28th as the first day of the new calendar year and any date after that until today's date is flagged as a 1?</P><P></P><P>Thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Current-YTD-Flag-creation-for-an-odd-start-and-end-date/m-p/687#M793572 ashleywooldridg 2020-11-25T16:16:04Z Re: Current YTD Flag creation for an odd start and end date https://community.qlik.com/t5/QlikView/Current-YTD-Flag-creation-for-an-odd-start-and-end-date/m-p/688#M793573 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(TempDate &gt;= (YearStart(Today(), 0, <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span> + 27) and TempDate &lt;= Today() 1, 0) as Flag</STRONG></P></BODY></HTML> Mon, 15 Jan 2018 18:21:07 GMT https://community.qlik.com/t5/QlikView/Current-YTD-Flag-creation-for-an-odd-start-and-end-date/m-p/688#M793573 sunny_talwar 2018-01-15T18:21:07Z Re: Current YTD Flag creation for an odd start and end date https://community.qlik.com/t5/QlikView/Current-YTD-Flag-creation-for-an-odd-start-and-end-date/m-p/689#M793574 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny,</P><P></P><P>If(TempDate &gt;= (YearStart(Today(), 0, 8)) + 27 and TempDate &lt;= Today(), 1, 0) AS Flag</P><P></P><P>Works perfectly.</P></BODY></HTML> Mon, 15 Jan 2018 23:12:39 GMT https://community.qlik.com/t5/QlikView/Current-YTD-Flag-creation-for-an-odd-start-and-end-date/m-p/689#M793574 ashleywooldridg 2018-01-15T23:12:39Z