Forum Discussion
- ToTimestamp([my date field],[My time of day field])
- 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. :)
- Can you tell us how you solved it? I am having the same issue.
- ToTimeStamp([my date field], [my timeofday field])
- 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.
- Look further down the field list for the formula field types.
- The picture has the whole list for a calculated column.
- I did follow the advice of creating a new field though and that worked.
- 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.
