3 Replies Latest reply on Dec 22, 2016 7:15 AM by beverly

    Trim question

    fmpro_novice

      Is there a way to trim an address from - example - 1/2/2017 to 1/2? I need to remove the forward slash before the year and the year.

       

      I have a mandatory field that requires someone to choose a date. That choice will produce month, day, year  ( 1/2/2017 )

      After this selection, I need to remove the last slash and the year to use in another part of the database so that only this is remaining ( 1/2 )..

       

      Thanks!