Forum Discussion

JeffreyWeide's avatar
JeffreyWeide
Qrew Trainee
4 years ago

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

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 curr...
Tables and fields
JeffPeterson1's avatar
JeffPeterson1
Qrew Captain
4 years ago
Try this:  [your timestamp in EST]-Hours(2)

------------------------------
Jeff Peterson
------------------------------
JeffreyWeide's avatar
JeffreyWeide
Qrew Trainee
4 years ago
Thanks! It actually required +2 hours to make it match in mountain time (so 8:00a MDT would be 10:00a EDT).

------------------------------
Jeffrey Weide
------------------------------