topic Re: date without special characters in QlikView https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976883#M643583 <HTML><HEAD></HEAD><BODY><P>Please try not to re-post the same questions twice</P></BODY></HTML> Wed, 23 Dec 2015 16:52:04 GMT sunny_talwar 2015-12-23T16:52:04Z date without special characters https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976881#M643581 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hello All </P><P style="font-size: 13.3333px;"> i m extracting the date from the web link in CSV format so the date is like "2015-02-05"] </P><P style="font-size: 13.3333px;">. now i need the date without special character like 2015-02-05 </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">kindly help me i will be very thankful</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Best Regards</P><P style="font-size: 13.3333px;">RHS&nbsp; </P><P style="font-size: 13.3333px;"></P><TABLE border="1" class="jiveBorder" height="49" style="border: 1px solid #000000; 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:25:03 GMT https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976881#M643581 2015-12-23T05:25:03Z Re: date without special characters https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976882#M643582 <HTML><HEAD></HEAD><BODY><P>You could use keepchar(date, '0123456789-')</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 23 Dec 2015 16:29:53 GMT https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976882#M643582 marcus_sommer 2015-12-23T16:29:53Z Re: date without special characters https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976883#M643583 <HTML><HEAD></HEAD><BODY><P>Please try not to re-post the same questions twice</P></BODY></HTML> Wed, 23 Dec 2015 16:52:04 GMT https://community.qlik.com/t5/QlikView/date-without-special-characters/m-p/976883#M643583 sunny_talwar 2015-12-23T16:52:04Z