Skip to main content

Guys,

We are using a flow to create a work order when an opportunity is "Closed Won". Most of the field info comes over just fine, but the Start and End date fields are remaining blank.

 

We created 2 formula objects in the flow because we wanted the start date/time to be 12 hours later and end date/time to be 20 hours later. Then added those into the "Create Work Order" create records object in the flow. Saved and activated the flow, but when tested these 2 fields didn't populate.

 

Reference formula for a Start/End date/time from an Oppty to a WO?flow2.PNG

 

flow.PNGEnd Date.PNGStart Date.PNG

When I reference the fields this way the date rolls to the Work Order but it's off by the 12 and 20 hours we need it to be.  Any help or advice? 

WO flow time.PNG

4 respostas
  1. 10 de nov. de 2022, 17:23

    Thank you so much!! I was able to get the problem fixed with your suggestion to move the brackets and used this formula. Appreciate the help!

    DATETIMEVALUE({!$Record.Estimated_Start_Date__c})+12/24
0/9000