Skip to main content
Question

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

How do I combine a manually entered Date field with a manually entered Time Field to generate a Date/Time field?
This topic has been closed for replies.

ToTimestamp([my date field],[My time of day field])
Forum|alt.badge.img
Also use Date / Time formula field
Hi, I keep getting an error when I try to do this? It tells me it was "expecting a datetime..." Any ideas?
Elana,
I suggest that you post a new question along with your current formula which is not working.
Thanks, I got it figured out. :) 
Look further down the field list for the formula field types.
can I use this formula to do something like the below?

ToTimestamp([my date field],"7:00")

what would the correct syntax be?
ToTimeStamp([my date field],ToTimeOfDay("7:00"))
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"))
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.
Great! Thank you Sir! 
Terms & ConditionsAccessibility statement