Calendar View With Date and Time

Question

Hello,I currently have a table that holds all of our tasks that is in a table-to-table relationship with our main customer table. When we create a task we have the date, time, and time of date (AM/PM) in separate inputs as the time of day input is very sluggish and not user-friendly. Where our issue comes is that we would like to put the items on a calendar view report from the task table, but we have no way to include all of the information into one field in a report formula. When I attempt to make them into a time of day formula I cannot get the [Task Date] (Date Field Type) &" "&[Task Time](Text Field)&" "&[Time of Day](Text Field) to work. We also need to add an end time which would be 30 minutes after the beginning time that we are attempting to create.Is there a way to accomplish this?------------------------------Benjamin Brooks------------------------------

MarkShnierYou · Answer

Are you simply saying that you want to have a separate input field for the date and the time of day and the formula field to create a formula date time field that you can use on the calendar?

Here is the function for that date time formula field.

https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=143&rl=bvm

if you then want to have a field which is 30 minutes later you can do this. [My start date time field] + minutes(30)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community