Forum Discussion

JillianP's avatar
JillianP
Qrew Member
2 years ago

Formula-Date/Time

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

Sort By
  • JeffPeterson1's avatar
    JeffPeterson1
    Qrew Captain
    2 years ago

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