How to auto-calculate Planned Start and Planned End dates using Flow Designer?

[Sahil Mir]

Hi Everyone,

I am working on a Change Request form and need help implementing date/time logic using Flow Designer.

Fields involved

• Actual Start Date
• Planned Start Date
• Planned End Date

Requirement

• The Planned Start Date should be 15 minutes greater than the Actual Start Date
  • Example: If Actual Start Date is 2:00 AM, Planned Start Date should be 2:15 AM
• The Planned End Date should be 24 hours greater than the Planned Start Date

Constraints

• This must be implemented only using Flow Designer.

Thanks in advance!

[Rakesh_M · Accepted solution]

Hello @Sahil Mir ,
1.Configure the trigger condition as follows:



2.Now, click on Action and select Update Record.



3.Select fields to be updated as Planned start date and Planned end date.
Using data pills select actual start date as value


4.Now click on function icon then Date & Time >> Add Time and enter 15 minutes and click apply.

5. Similarly add time to planned end date and apply.

[Rakesh_M · Accepted solution]

Hi @Sahil Mir ,
1.as per your requirement,

The Planned End Date should be 24 hours greater than the Planned Start Date
Planned start date=Actual start date + 15 minutes
so, Planned end date =Planned start date +24 hours
which is PED = Actual start date +24 hours +15 minutes
           



2.Yes this works on form level,
--Create any change record,For example create a emergency Change
--Then request approval -> state changes to authorize
--After Approval -> state changes to schedule
-- Now when we click on implement the actual start date populates

--As per our trigger conditions when state changes to implement the flow executes
now refresh the form ,the planned dates will get populated.

[Sahil Mir]

Thank you so much @Rakesh_M  now it is working finely.

[Ankur Bawiskar]

@Sahil Mir 

so what you started and where are you stuck?

share screenshots

[Sahil Mir]

Hi @Ankur Bawiskar.
I did it, now it is working but the problem is it's not working on form level, it only works when I'm testing any change request from flow. How will it work on form level? 
I have attached two screenshots for you. ( problem 3 ) ss is when I'm testing it form flow and ( problem 4 ) is when I'm directly making change on form level in change table. 

[Ankur Bawiskar · Accepted solution]

@Sahil Mir 

flow runs in background and once record saved it will take some time to reflect the form changes

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏