Trimming a string

[#1]

I have 2 dates taken from different files, and keep getting quotation marks on one of the strings, i cant remove them since the program gets the data like that every update, how do i trim my string to not contain the " since it makes the printed date look like trash.

It currently prints it like "2222-02-22" i want it to print 2222-02-22 but i cant change the data.

[arvind_patil · Accepted solution]

Hi Linus,

Try this :

Purgechar([DateField],'"') As [New Date]

Thanks,

Arvind Patil

[#3]

Thanks dude works perfectly

[arvind_patil]

Hi Linus,

Please mark it as a correct ans.

Thanks,

Arvind Patil