topic DATA MONTHNAME in Brasil https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244970#M44236 <HTML><HEAD></HEAD><BODY><P>Boa tarde!</P><P></P><P>Estou com duvidas para montar um calendário que inicia do dia 16 ao dia 15 do próximo mês tenho um campo DATA.</P><P></P><P>Inicialmente foi aplicado a expressão no script abaixo:</P><P></P><P>Monthname(Data + 16) as Mes</P><P></P><P>O problema ocorre no mês que tem 31 dias setembro: 16/08 a <SPAN style="color: #ff0000;">14/09 </SPAN><SPAN style="color: #000000;">Deveria ser dia 15/09.</SPAN></P></BODY></HTML> Wed, 28 Dec 2016 16:20:55 GMT 2016-12-28T16:20:55Z DATA MONTHNAME https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244970#M44236 <HTML><HEAD></HEAD><BODY><P>Boa tarde!</P><P></P><P>Estou com duvidas para montar um calendário que inicia do dia 16 ao dia 15 do próximo mês tenho um campo DATA.</P><P></P><P>Inicialmente foi aplicado a expressão no script abaixo:</P><P></P><P>Monthname(Data + 16) as Mes</P><P></P><P>O problema ocorre no mês que tem 31 dias setembro: 16/08 a <SPAN style="color: #ff0000;">14/09 </SPAN><SPAN style="color: #000000;">Deveria ser dia 15/09.</SPAN></P></BODY></HTML> Wed, 28 Dec 2016 16:20:55 GMT https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244970#M44236 2016-12-28T16:20:55Z Re: DATA MONTHNAME https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244971#M44237 <HTML><HEAD></HEAD><BODY><P>Provide some more information about your requirement !</P><P>It is unclear from your question, what exactly you want!</P></BODY></HTML> Wed, 28 Dec 2016 19:02:03 GMT https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244971#M44237 MK_QSL 2016-12-28T19:02:03Z Re: DATA MONTHNAME https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244972#M44238 <HTML><HEAD></HEAD><BODY><P>Boa tarde!</P><P></P><P>Estou usando a função monthname(data+16) em um campo de data.</P><P></P><P>Onde tenho os intervalos:</P><P>16/06 a 15/07</P><P>16/07 a 15/08</P><P>16/08 a 14/09&nbsp; o correto seria 15/09</P><P>15/09 a 15/10 &gt;&gt; 16/09 a 15/10</P><P></P><P>São intervalos fixos.</P></BODY></HTML> Wed, 28 Dec 2016 19:09:50 GMT https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244972#M44238 2016-12-28T19:09:50Z Re: DATA MONTHNAME https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244973#M44239 <HTML><HEAD></HEAD><BODY><P>Still don't understand. Sorry for that. Can you provide few dates and end result along with result?</P></BODY></HTML> Wed, 28 Dec 2016 19:14:18 GMT https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244973#M44239 MK_QSL 2016-12-28T19:14:18Z Re: DATA MONTHNAME https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244974#M44240 <HTML><HEAD></HEAD><BODY><P>Tenta assim:</P><P>Monthname(AddMonths(Data, if(Day(Data)&gt;15,1,0))) as Mes</P></BODY></HTML> Thu, 29 Dec 2016 17:45:47 GMT https://community.qlik.com/t5/Brasil/DATA-MONTHNAME/m-p/1244974#M44240 Clever_Anjos 2016-12-29T17:45:47Z