Skip to main content
Nintex Community Menu Bar
Solved

DateDiff in o365 form

  • August 26, 2017
  • 3 replies
  • 17 views
  • Translate

Forum|alt.badge.img+6

I'm sure this is a big newbie question.  

 

I want to display the date difference between two dates.

 

I placed a calculated value field on my form and set the formula to : dateDiffdays(StartDate,EndDate) <StartDate and EndDate are entered on the form.  They are columns in my list>

 

preview the form.  Enter my start and end date. My calculated value field just stares at me... kind of unnerving.  Show me the date difference!  

 

Thanks for your help!

Best answer by lakshminarayana

I saw both fields and controls names are same, but when you writing formula for calculated field what you selected 'item properties' or 'named controls'.

please select references from 'named controls'.

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+9

Are you using Named Controls or Connected to fields from field settings? Use Named Controls and check it.

Translate

Forum|alt.badge.img+6

It all looks the same but a different result.

The list where the named fields (startdate, enddate) are defined.

This is how the form is configured

Translate

Forum|alt.badge.img+9

I saw both fields and controls names are same, but when you writing formula for calculated field what you selected 'item properties' or 'named controls'.

please select references from 'named controls'.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings