Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
To Text Date Formula- I want / instead of -
Bethany Hudson
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 (/). ...
Tyler Jablonski
08-19-2021 15:11
SearchAndReplace(ToText([Date Field]), "-", "/") ------------------------------ Tyler Jablonski ------------------------------ ...
Bethany Hudson
08-19-2021 15:25
Perfect! Thank you! -- Bethany Hudson Program Administrator Mobile ...
1.
To Text Date Formula- I want / instead of -
0
Like
Bethany Hudson
Posted 08-19-2021 13:48
Reply
Reply Privately
Options Dropdown
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 -
0
Like
Tyler Jablonski
Posted 08-19-2021 15:11
Reply
Reply Privately
Options Dropdown
SearchAndReplace(ToText([Date Field]), "-", "/")
------------------------------
Tyler Jablonski
------------------------------
Original Message
Original Message:
Sent: 08-19-2021 13:47
From: Bethany Hudson
Subject: To Text Date Formula- I want / instead of -
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
------------------------------
3.
RE: To Text Date Formula- I want / instead of -
0
Like
Bethany Hudson
Posted 08-19-2021 15:25
Reply
Reply Privately
Options Dropdown
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
www.mobilebaynep.com
www.cleanwaterfuture.com
Original Message
Original Message:
Sent: 8/19/2021 3:11:00 PM
From: Tyler Jablonski
Subject: RE: To Text Date Formula- I want / instead of -
SearchAndReplace(ToText([Date Field]), "-", "/")
------------------------------
Tyler Jablonski
------------------------------
Original Message:
Sent: 08-19-2021 13:47
From: Bethany Hudson
Subject: To Text Date Formula- I want / instead of -
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
------------------------------
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic