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

Question

Hi there, everyone.&nbsp;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 &amp;2) Combine the Date, Arrival time, and Duration (in hours) to create an end time field------------------------------Jeffrey Weide------------------------------

jeffreyweide · Answer

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
------------------------------

jeffpeterson1 · Answer

Try this:&nbsp; [your timestamp in EST]-Hours(2)------------------------------Jeff Peterson------------------------------

jeffreyweide · Answer

Thanks! It actually required +2 hours to make it match in mountain time (so 8:00a MDT would be 10:00a EDT).------------------------------Jeffrey Weide------------------------------

Forum Discussion

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