Discussions

 View Only
Expand all | Collapse all

How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?

JeffJoyce JeffJoyce

JeffJoyce JeffJoyce04-25-2014 17:07

QuickBaseCoach Dev./Training

QuickBaseCoach Dev./Training04-25-2014 17:09

Derek Anderson

Derek Anderson03-17-2017 05:01

Elena Larrabee

Elena Larrabee04-03-2018 16:07

QuickBaseCoach Dev./Training

QuickBaseCoach Dev./Training07-31-2018 17:35

Elena Larrabee

Elena Larrabee07-31-2018 17:45

Chris Newsome

Chris Newsome07-31-2018 18:26

QuickBaseCoach Dev./Training

QuickBaseCoach Dev./Training07-31-2018 18:51

QuickBaseCoach Dev./Training

QuickBaseCoach Dev./Training10-18-2018 18:46

Francesco Spiga

Francesco Spiga10-18-2018 18:58

  • 1.  How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?

    Posted 04-25-2014 17:07


  • 2.  RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?

    Posted 04-25-2014 17:09
    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?

    Posted 03-17-2017 05:01
    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?

    Posted 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 ideas?


  • 5.  RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?

    Posted 04-03-2018 15:51
    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?

    Posted 04-03-2018 16:07
    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?

    Posted 07-31-2018 17:25
    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?

    Posted 07-31-2018 17:35
    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?

    Posted 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" 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?

    Posted 07-31-2018 17:45
    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?

    Posted 07-31-2018 17:45
    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?

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

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

    Posted 07-31-2018 18:26


  • 15.  RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?

    Posted 07-31-2018 18:27
    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?

    Posted 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 table. 


  • 17.  RE: How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?

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

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

    Posted 07-31-2018 19:02
    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?

    Posted 07-31-2018 19:14
    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?

    Posted 07-31-2018 19:14
    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?

    Posted 07-31-2018 18:51
    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?

    Posted 07-31-2018 19:01
    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?

    Posted 07-31-2018 19:01
    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?

    Posted 10-18-2018 18:43
    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?

    Posted 10-18-2018 18:46
    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?

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

    Posted 10-18-2018 18:57
    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?

    Posted 10-18-2018 18:58
    Great! Thank you Sir!