date without special characters

[#1]

Hello All

i m extracting the date from the web link in CSV format so the date is like "2015-02-05"]

. now i need the date without special character like 2015-02-05

kindly help me i will be very thankful

Best Regards

RHS 

Date
"2015-02-05"]

[Gysbert_Wassenaar]

Try Date(Date#(PurgeChar(Date,'"]'),'YYYY-MM-DD'),'YYYY-MM-DD')

[sunny_talwar]

This also might work:

=Date(Date#('"2015-02-05"', '"YYYY-MM-DD"'))

in the script:

Date(Date#(DateField, '"YYYY-MM-DD"')) as DateField