Forum Discussion
ElenaLarrabee1
8 years agoQrew Captain
Thanks, I got it figured out. :)
- ChrisNewsome7 years agoQrew CaptainCan you tell us how you solved it? I am having the same issue.
- QuickBaseCoachD7 years agoQrew CaptainToTimeStamp([my date field], [my timeofday field])
- ChrisNewsome7 years agoQrew CaptainSo 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. - ElenaLarrabee17 years agoQrew CaptainDate/Time formula field
- ElenaLarrabee17 years agoQrew CaptainToTimestamp([Date],If(IsNull([Time]),ToTimeOfDay("12:00am"),[Time]))
- ChrisNewsome7 years agoQrew Captainthere 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. - ElenaLarrabee17 years agoQrew CaptainHuh, 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!
- ChrisNewsome7 years agoQrew Captain
- ChrisNewsome7 years agoQrew CaptainHere's what I'm seeing. Thanks for the help!
- ElenaLarrabee17 years agoQrew CaptainYou're trying to create a calculated column? I would just create a new date/time formula field in that table.