Skip to main content
Question

Formula-Date/Time

  • Mar 3, 2023 7:35 PM UTC
  • 0 replies
  • 141 views

I ran into an issue with our Work Order calendar report showing the appointments at the top rather than in their respective time slot. I did some research and realized the issue is stemming from me trying to utilize two fields – one to track date and one to track time of day. I need to use a date/time field specifically that holds both. If I were to use a formula-date/time field to combine existing data, how would this formula look?

My fields are "Work Order Date" and "Start Time".



------------------------------
Jillian P
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • Qrew Colonel
  • Mar 4, 2023 12:26 AM UTC

Assuming [Work Order Date] is a date-type field and [Start Time] is a time of day type field:

ToTimestamp([Work Order Date], [Start Time])



------------------------------
Jeff Peterson
------------------------------