Skip to main content
Question

Formula-Date/Time

  • March 3, 2023
  • 0 replies
  • 130 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
  • Registered
  • March 4, 2023

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