Discussions

Expand all | Collapse all

To Text Date Formula- I want / instead of -

  • 1.  To Text Date Formula- I want / instead of -

    Posted 08-19-2021 13:48
    I've got a ToText field for a few Date fields but instead of a dash (-), I want it to have slashes (/). Is there a way to do this?

    ------------------------------
    Bethany Hudson
    ------------------------------


  • 2.  RE: To Text Date Formula- I want / instead of -

    Posted 08-19-2021 15:11
    SearchAndReplace(ToText([Date Field]), "-", "/")

    ------------------------------
    Tyler Jablonski
    ------------------------------



  • 3.  RE: To Text Date Formula- I want / instead of -

    Posted 08-19-2021 15:25
    Perfect! Thank you!

    --

    Bethany Hudson
    Program Administrator
    Mobile Bay National Estuary Program
    118 North Royal Street
    Suite 601
    Mobile, AL 36602
    (o) 251-459-8870
    (c) 251-367-1368