topic Re: date without special characters in QlikView https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976671#M947300 <HTML><HEAD></HEAD><BODY><P>Try Date(Date#(PurgeChar(Date,'"]')<SPAN style="font-size: 13.3333px;">,'YYYY-MM-DD')<SPAN style="font-size: 13.3333px;">,'YYYY-MM-DD')</SPAN></SPAN></P></BODY></HTML> Wed, 23 Dec 2015 16:46:25 GMT Gysbert_Wassenaar 2015-12-23T16:46:25Z date without special characters https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976670#M947299 <HTML><HEAD></HEAD><BODY><P>Hello All </P><P> i m extracting the date from the web link in CSV format so the date is like "2015-02-05"] </P><P>. now i need the date without special character like 2015-02-05 </P><P></P><P>kindly help me i will be very thankful</P><P></P><P>Best Regards</P><P>RHS&nbsp; </P><P></P><TABLE border="1" class="jiveBorder" height="49" style="border: 1px solid rgb(0, 0, 0); width: 86px; height: 43px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH></TR><TR><TD style="padding: 2px;">"2015-02-05"]</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 23 Dec 2015 05:24:10 GMT https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976670#M947299 2015-12-23T05:24:10Z Re: date without special characters https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976671#M947300 <HTML><HEAD></HEAD><BODY><P>Try Date(Date#(PurgeChar(Date,'"]')<SPAN style="font-size: 13.3333px;">,'YYYY-MM-DD')<SPAN style="font-size: 13.3333px;">,'YYYY-MM-DD')</SPAN></SPAN></P></BODY></HTML> Wed, 23 Dec 2015 16:46:25 GMT https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976671#M947300 Gysbert_Wassenaar 2015-12-23T16:46:25Z Re: date without special characters https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976672#M947301 <HTML><HEAD></HEAD><BODY><P>This also might work:</P><P></P><P><STRONG>=Date(Date#('"2015-02-05"', '"YYYY-MM-DD"'))</STRONG></P><P></P><P>in the script:</P><P></P><P><STRONG>Date(Date#(DateField</STRONG><STRONG style="font-size: 13.3333px;">, '"YYYY-MM-DD"')) as DateField</STRONG></P></BODY></HTML> Wed, 23 Dec 2015 16:50:06 GMT https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976672#M947301 sunny_talwar 2015-12-23T16:50:06Z