Date with time stamp

[Centaur]

Hello experts,

I have field [Invoice #] formatted as text that, if a date, it adds a time stamp to it.  

How can I remove the time stamp?  The field must be text since there are dates, numbers, text and numbers in this field.

thank you

[durack99 · Accepted solution]

give this one a try winner

[Centaur]

Excellent!  Worked perfectly.  thank you very much.