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
Separate Date/Time Field to Date Field and Time Field
Brittany Brittany
08-10-2017 19:10
Our Date/Time field is inputted by mass import. Is there a formula I can use to separate the Date/Time ...
QuickBaseCoach Dev./Training
08-10-2017 19:59
No problem. One of the fields will be a formula Time Of Day field type ToTimeOfDay([my date/time field]) ...
Brittany Brittany
08-10-2017 20:01
Thank you!
1.
Separate Date/Time Field to Date Field and Time Field
1
Like
Brittany Brittany
Posted 08-10-2017 19:10
Reply
Reply Privately
Options Dropdown
Our Date/Time field is inputted by mass import. Is there a formula I can use to separate the Date/Time field into 2 fields - Date & Time of Day?
I like the combined Date/Time field for table reports, but want to use the separate Date & Time of Day fields for a calendar report.
2.
RE: Separate Date/Time Field to Date Field and Time Field
1
Like
QuickBaseCoach Dev./Training
Posted 08-10-2017 19:59
Reply
Reply Privately
Options Dropdown
No problem.
One of the fields will be a formula Time Of Day field type
ToTimeOfDay([my date/time field])
The other will be a formula Date field type
ToDate([my date/time field])
3.
RE: Separate Date/Time Field to Date Field and Time Field
0
Like
Brittany Brittany
Posted 08-10-2017 20:01
Reply
Reply Privately
Options Dropdown
Thank you!
×
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