AnsweredAssumed Answered

How to delete a space from the middle of a date

Question asked by user447 on May 17, 2010
Latest reply on May 17, 2010 by user447

Title

How to delete a space from the middle of a date

Post

I've imported several date fields and many were originally entered with an extra space within the date.  For instance:  7/ 3/ 08

A calculation based on that field will not work unless it is retyped or re-entered as 7/3/08 with those extra spaces deleted.

How can I remove them?  Isn't TrimAll just for leading and trailing spaces?

Thanks for any suggestions!

Jane in LR

 

 

Outcomes