Forum Discussion

Centaur's avatar
Centaur
Helper V
2 years ago
Solved

Date with time stamp

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

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    give this one a try winner

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    give this one a try winner

     

     

    • Centaur's avatar
      Centaur
      Helper V

      Excellent!  Worked perfectly.  thank you very much.