question Re: How to auto-calculate Planned Start and Planned End dates using Flow Designer? in Community Central forum

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

Sahil Mir — Tue, 07 Apr 2026 06:06:22 GMT

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!

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

Rakesh_M — Tue, 07 Apr 2026 06:36:30 GMT

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.

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

Rakesh_M — Tue, 07 Apr 2026 06:38:38 GMT

Hello @Sahil Mir ,
I wanted to add: please configure the trigger condition as per the requirement.

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

Ankur Bawiskar — Tue, 07 Apr 2026 06:54:14 GMT

@Sahil Mir

so what you started and where are you stuck?

share screenshots

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

Sahil Mir — Tue, 07 Apr 2026 08:45:31 GMT

Hi @Rakesh_M.
I have set up all the condition correctly and it is working fine but the thing is for the third field which is planning end date it is adding the day but not the time correctly. Like if Planning start date is 2025-04-17 12:15:00 then the planning end date should be 2025-04-18 12:15:00. It is adding time 15 minutes less. I have attached the screen shot for your reference kindly check it and tell me where I'm making mistake.
One more thing can I test it directly from change record, like if I make some changes on change record on form level will it work there?

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

Sahil Mir — Tue, 07 Apr 2026 09:19:33 GMT

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.

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

Rakesh_M — Tue, 07 Apr 2026 09:22:28 GMT

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.

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

Sahil Mir — Tue, 07 Apr 2026 10:02:49 GMT

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

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

Ankur Bawiskar — Tue, 07 Apr 2026 10:15:25 GMT

@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! 🙏