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.

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

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

[Sahil Mir]

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?

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