To Text Date Formula- I want / instead of -

Question

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
------------------------------

tylerjablonski1 · Answer

SearchAndReplace(ToText([Date Field]), "-", "/")------------------------------Tyler Jablonski------------------------------

bethanyhudson · Answer

Perfect! Thank you!-- Bethany HudsonProgram AdministratorMobile Bay National Estuary Program118 North Royal StreetSuite 601Mobile, AL 36602(o) 251-459-8870(c) 251-367-1368www.mobilebaynep.comwww.cleanwaterfuture.com

Forum Discussion

To Text Date Formula- I want / instead of -