topic Re: Formatar Campo in Brasil https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250791#M44500 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="pt">Por favor, trt</SPAN></P><P><SPAN class="short_text" lang="pt"></SPAN></P><P><SPAN class="short_text" lang="pt"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/149518_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/149519_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Sun, 15 Jan 2017 12:48:52 GMT girirajsinh 2017-01-15T12:48:52Z Formatar Campo https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250790#M44499 <HTML><HEAD></HEAD><BODY><P>Bom Dia.!</P><P></P><P>Como eu formato um campo data para um dia da semana.</P><P></P><P><STRONG>Ex:</STRONG></P><P></P><P>06/01/2017 <STRONG>para</STRONG> Sexta-Feira</P><P></P><P>Muito Obrigado.!</P></BODY></HTML> Sun, 15 Jan 2017 11:55:09 GMT https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250790#M44499 girino777 2017-01-15T11:55:09Z Re: Formatar Campo https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250791#M44500 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="pt">Por favor, trt</SPAN></P><P><SPAN class="short_text" lang="pt"></SPAN></P><P><SPAN class="short_text" lang="pt"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/149518_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/149519_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Sun, 15 Jan 2017 12:48:52 GMT https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250791#M44500 girirajsinh 2017-01-15T12:48:52Z Re: Formatar Campo https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250792#M44501 <HTML><HEAD></HEAD><BODY><P>Bom Dia.!</P><P></P><P>Fiz desta forma, porém está abreviando o texto.</P><P><STRONG>Ex:</STRONG> seg, ter, ......</P><P></P><P style="font-size: 13.3333px;">SET DateFormat = 'DD/MM/YYYY';</P><P style="font-size: 13.3333px;">SET DayNames='segunda-feira;terça-feira;quarta-feira;quinta-feira;sexta-feira;sábado;domingo';</P><P style="font-size: 13.3333px;">SET LongDayNames='segunda-feira;terça-feira;quarta-feira;quinta-feira;sexta-feira;sábado;domingo';</P><P></P><P>Gostaria que fosse assim:</P><P><STRONG>Ex:</STRONG> segunda-feira, terça-feira, .......</P></BODY></HTML> Mon, 16 Jan 2017 10:55:14 GMT https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250792#M44501 girino777 2017-01-16T10:55:14Z Re: Formatar Campo https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250793#M44502 <HTML><HEAD></HEAD><BODY><P>Amigo, tente:</P><P></P><P>Date([CampoData],'wwww')</P><P></P><P>ou</P><P></P><P>Capitalize(Date([<SPAN style="font-size: 13.3333px;">CampoData</SPAN>],'<SPAN style="font-size: 13.3333px;">wwww</SPAN>')) //Primeira letra de cada palavra em maiúsculo</P></BODY></HTML> Mon, 16 Jan 2017 11:03:47 GMT https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250793#M44502 mario_sergio_ti 2017-01-16T11:03:47Z Re: Formatar Campo https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250794#M44503 <HTML><HEAD></HEAD><BODY><P>Date(weekday(datefield) ,'WWWW') Or Date(datefield ,'WWWW')</P></BODY></HTML> Mon, 16 Jan 2017 11:21:19 GMT https://community.qlik.com/t5/Brasil/Formatar-Campo/m-p/1250794#M44503 girirajsinh 2017-01-16T11:21:19Z