Forum Discussion

JeffreyWeide's avatar
JeffreyWeide
Qrew Trainee
3 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
JeffreyWeide's avatar
JeffreyWeide
Qrew Trainee
3 years ago
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's avatar
    JeffPeterson1
    Qrew Captain
    3 years ago
    Try this:  [your timestamp in EST]-Hours(2)

    ------------------------------
    Jeff Peterson
    ------------------------------
    • JeffreyWeide's avatar
      JeffreyWeide
      Qrew Trainee
      3 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
      ------------------------------