Forum Discussion

JillianP's avatar
Qrew Member
2 years ago


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

1 Reply

  • 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