Skip to main content
Question

Combining a Date field and Time field for Date/Time field to use in iCal field

  • December 1, 2021
  • 0 replies
  • 100 views
Hi there, everyone. 

Not used to the nuances of dates and times in QB yet. From our client, we get requests for a date, time, and duration to work a site we will work. I have these items in my current scheduler, but I was hoping to auto-generate iCal for staff using the iCal function in QB using data. For the Start and End time fields in the iCal, it needs a Date/Time field. So, is there a way to:

1) Combine the Date and Arrival time to create a start time field &
2) Combine the Date, Arrival time, and Duration (in hours) to create an end time field

------------------------------
Jeffrey Weide
------------------------------
This topic has been closed for replies.

  • JeffreyWeide
  • Author
  • Registered
  • December 1, 2021
Update, figured that out using the ToTimestamp function, but just have to adjust since the company is based out of EST and clients are in MST. Any ideas on best way to verify timezones on time data?

------------------------------
Jeffrey Weide
------------------------------
    Terms & ConditionsAccessibility statement