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
How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
JeffJoyce JeffJoyce
04-25-2014 17:07
QuickBaseCoach Dev./Training
04-25-2014 17:09
ToTimestamp([my date field],[My time of day field])
Derek Anderson
03-17-2017 05:01
Also use Date / Time formula field
Elena Larrabee
04-03-2018 15:33
Hi, I keep getting an error when I try to do this? It tells me it was "expecting a datetime..." Any ...
QuickBaseCoach Dev./Training
04-03-2018 15:51
Elana, I suggest that you post a new question along with your current formula which is not working.
Elena Larrabee
04-03-2018 16:07
Thanks, I got it figured out. :)
Chris Newsome
07-31-2018 17:25
Can you tell us how you solved it? I am having the same issue.
QuickBaseCoach Dev./Training
07-31-2018 17:35
ToTimeStamp([my date field], [my timeofday field])
Chris Newsome
07-31-2018 17:37
So what type do I set this to? If I choose "Date" I get the error "expecting date but found datetime" ...
Elena Larrabee
07-31-2018 17:45
ToTimestamp([Date],If(IsNull([Time]),ToTimeOfDay("12:00am"),[Time]))
Elena Larrabee
07-31-2018 17:45
Date/Time formula field
Chris Newsome
07-31-2018 18:20
there isn't a date/time formula field type option. I still get the same error because I can only choose ...
Elena Larrabee
07-31-2018 18:23
Huh, sorry then, I'm not sure why you wouldn't be able to create a date/time formula field. That's ...
Chris Newsome
07-31-2018 18:26
Chris Newsome
07-31-2018 18:27
Here's what I'm seeing. Thanks for the help!
Elena Larrabee
07-31-2018 18:29
You're trying to create a calculated column? I would just create a new date/time formula field in that ...
Chris Newsome
07-31-2018 18:59
Duh! That worked... I had thought I could just make a calculated column on the report to do that for ...
Chris Newsome
07-31-2018 19:00
One issue I noticed is that if the activity doesn't have a time associated, it doesn't display on the ...
Elena Larrabee
07-31-2018 19:02
That's what the if null then midnight part is for
Chris Newsome
07-31-2018 19:14
yep I kind of solved that after I wrote the post... thanks again!
Chris Newsome
07-31-2018 19:14
yep I kind of solved that after I wrote the post... thanks again!
QuickBaseCoach Dev./Training
07-31-2018 18:51
Look further down the field list for the formula field types.
Chris Newsome
07-31-2018 19:01
The picture has the whole list for a calculated column.
Chris Newsome
07-31-2018 19:01
I did follow the advice of creating a new field though and that worked.
Francesco Spiga
10-18-2018 18:43
can I use this formula to do something like the below? ToTimestamp([my date field],"7:00") what would ...
QuickBaseCoach Dev./Training
10-18-2018 18:46
ToTimeStamp([my date field],ToTimeOfDay("7:00"))
Francesco Spiga
10-18-2018 18:55
Thanks for your quick reply. What if I would like to add 1 day to [my date field]? ToTimeStamp([my ...
QuickBaseCoach Dev./Training
10-18-2018 18:57
ToTimeStamp([my date field]+Days(1)),ToTimeOfDay("7:00")) or you could also do ToTimeStamp([my date ...
Francesco Spiga
10-18-2018 18:58
Great! Thank you Sir!
1.
How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
JeffJoyce JeffJoyce
Posted 04-25-2014 17:07
Reply
Reply Privately
Options Dropdown
2.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
QuickBaseCoach Dev./Training
Posted 04-25-2014 17:09
Reply
Reply Privately
Options Dropdown
ToTimestamp([my date field],[My time of day field])
3.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Derek Anderson
Posted 03-17-2017 05:01
Reply
Reply Privately
Options Dropdown
Also use Date / Time formula field
4.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Elena Larrabee
Posted 04-03-2018 15:33
Reply
Reply Privately
Options Dropdown
Hi, I keep getting an error when I try to do this? It tells me it was "expecting a datetime..." Any ideas?
5.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
QuickBaseCoach Dev./Training
Posted 04-03-2018 15:51
Reply
Reply Privately
Options Dropdown
Elana,
I suggest that you post a new question along with your current formula which is not working.
6.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Elena Larrabee
Posted 04-03-2018 16:07
Reply
Reply Privately
Options Dropdown
Thanks, I got it figured out. :)
7.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 17:25
Reply
Reply Privately
Options Dropdown
Can you tell us how you solved it? I am having the same issue.
8.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
QuickBaseCoach Dev./Training
Posted 07-31-2018 17:35
Reply
Reply Privately
Options Dropdown
ToTimeStamp([my date field], [my timeofday field])
9.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 17:37
Reply
Reply Privately
Options Dropdown
So what type do I set this to? If I choose "Date" I get the error "expecting date but found datetime" and if I set to time, I get "expecting time but..."
I'm trying to get the calendar reports to place the events in their time slot, but we use separate date / time fields.
10.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Elena Larrabee
Posted 07-31-2018 17:45
Reply
Reply Privately
Options Dropdown
ToTimestamp([Date],If(IsNull([Time]),ToTimeOfDay("12:00am"),[Time]))
11.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Elena Larrabee
Posted 07-31-2018 17:45
Reply
Reply Privately
Options Dropdown
Date/Time formula field
12.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 18:20
Reply
Reply Privately
Options Dropdown
there isn't a date/time formula field type option.
I still get the same error because I can only choose from date or time types.
I have
[scheduled activity date]
[scheduled start time]
as my fields.
13.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Elena Larrabee
Posted 07-31-2018 18:23
Reply
Reply Privately
Options Dropdown
Huh, sorry then, I'm not sure why you wouldn't be able to create a date/time formula field. That's what I did, and the above formula is what I used to combine my separate date and time fields. Good luck!
14.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 18:26
Reply
Reply Privately
Options Dropdown
15.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 18:27
Reply
Reply Privately
Options Dropdown
Here's what I'm seeing. Thanks for the help!
16.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Elena Larrabee
Posted 07-31-2018 18:29
Reply
Reply Privately
Options Dropdown
You're trying to create a calculated column? I would just create a new date/time formula field in that table.
17.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 18:59
Reply
Reply Privately
Options Dropdown
Duh! That worked... I had thought I could just make a calculated column on the report to do that for me. Thanks for your help!
18.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 19:00
Reply
Reply Privately
Options Dropdown
One issue I noticed is that if the activity doesn't have a time associated, it doesn't display on the calendar. I assume I can add to the formula and correct that...?
19.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Elena Larrabee
Posted 07-31-2018 19:02
Reply
Reply Privately
Options Dropdown
That's what the if null then midnight part is for
20.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 19:14
Reply
Reply Privately
Options Dropdown
yep I kind of solved that after I wrote the post... thanks again!
21.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 19:14
Reply
Reply Privately
Options Dropdown
yep I kind of solved that after I wrote the post... thanks again!
22.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
QuickBaseCoach Dev./Training
Posted 07-31-2018 18:51
Reply
Reply Privately
Options Dropdown
Look further down the field list for the formula field types.
23.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 19:01
Reply
Reply Privately
Options Dropdown
The picture has the whole list for a calculated column.
24.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Chris Newsome
Posted 07-31-2018 19:01
Reply
Reply Privately
Options Dropdown
I did follow the advice of creating a new field though and that worked.
25.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Francesco Spiga
Posted 10-18-2018 18:43
Reply
Reply Privately
Options Dropdown
can I use this formula to do something like the below?
ToTimestamp([my date field],"7:00")
what would the correct syntax be?
26.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
QuickBaseCoach Dev./Training
Posted 10-18-2018 18:46
Reply
Reply Privately
Options Dropdown
ToTimeStamp([my date field],ToTimeOfDay("7:00"))
27.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Francesco Spiga
Posted 10-18-2018 18:55
Reply
Reply Privately
Options Dropdown
Thanks for your quick reply. What if I would like to add 1 day to [my date field]?
ToTimeStamp([my date field]+1,ToTimeOfDay("7:00"))
28.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
QuickBaseCoach Dev./Training
Posted 10-18-2018 18:57
Reply
Reply Privately
Options Dropdown
ToTimeStamp([my date field]+Days(1)),ToTimeOfDay("7:00"))
or you could also do
ToTimeStamp([my date field],ToTimeOfDay("7:00")) + Days(1)
either will work so use the one that makes more sense to you.
29.
RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
0
Like
Francesco Spiga
Posted 10-18-2018 18:58
Reply
Reply Privately
Options Dropdown
Great! Thank you Sir!
×
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