cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Difference on Two field values

Jump to solution

I need to find the difference between two date & time fields , and if its difference is greater than 10 minutes, a text box should be shown ,otherwise hide textbox.

So I created a list with two fields - Incident_started - with date & time  type

                                                       Shutdown_Initiated -  same type

And created a form with two tabs .And connected date fields in form to the list

for comment section wrote a condition

 do i need to store the difference in another column in the list ? please help me in writing the condition for comment section.

Thanks in advance

Labels: (1)
Tags (1)
0 Kudos
Reply
2 Replies
Highlighted
Workflow Hero

Re: Difference on Two field values

Jump to solution

I did this using a calculated value control to get the difference in minutes with this expression:

dateDiffMinutes(DateOfIncident,DateOfShutdown)

I called the calculated value control "DateDiffMins"

I then added a formatting rule on comments box with condition:

lessThan(DateDiffMins,10)

Reply
Workflow Hero

Re: Difference on Two field values

Jump to solution

for rule there is sufficient formula like

dateDiffMinutes(Date_Incident,Shutdown_Initiated)<10

make sure Date_incident and Shutdown_Initiated refers to named controls and not item properties.

Reply