Calendar View With Date and Time
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
------------------------------
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
------------------------------
