Skip to main content
Nintex Community Menu Bar

calculated date in nintex forms that won't work

  • Dec 6, 2017 8:24 PM UTC
  • 12 replies
  • 43 views
  • Translate All

Forum|alt.badge.img+6

Hello! I have screenshots with my question so it is attached.

12 replies

Forum|alt.badge.img+8
  • Dec 6, 2017 9:44 PM UTC

If you want a field with a value that is 122 days out from a given date field just create a calculated field such as the one in my screenshot below. This is just standard SharePoint functionality.

211291_pastedImage_1.png

Translate

Forum|alt.badge.img+8
  • Dec 6, 2017 9:46 PM UTC

You can check it, but Apr 9, 2018 is 122 days out from Dec 8, 2017.

211292_pastedImage_1.png

211293_pastedImage_2.png

Translate

Forum|alt.badge.img+12
  • Nintex Partner
  • Dec 6, 2017 9:55 PM UTC

Hello Jennifer,

Rules are used for validation and formatting of Nintex form controls, but not for any calculations.

Your requirement is to show the "request completion date" as per the selected request date, I would suggest to use "Calculated Field" control on your form to show that date as shown below.

1. Place a "Calculated Field" next to your "Requested Date" control

2. In "Calculated Field" settings --> create formula for adding 122 days.

Translate

Forum|alt.badge.img+6

Krishna Chaluvadi and  I added follow up questions and screenshots in an attachment.

Translate

Forum|alt.badge.img+12
  • Nintex Partner
  • Dec 6, 2017 11:11 PM UTC

I see you have mentioned "+122" in the formula, please remove the +.

Translate

Forum|alt.badge.img+8
  • Dec 6, 2017 11:32 PM UTC

I'm curious why you paste screenshots and questions in a word doc. You can paste screenshots right in your post. Putting them in a word doc in the original post makes it hard to follow the thread.

Translate

Forum|alt.badge.img+14
  • Scholar
  • Dec 7, 2017 8:58 AM UTC

if you want to populate date control with a value, only option is to use javascript.

if you use calculated value control, it can calculate date as you need, but you can not edit edit/change value in calculated value control.

you have to decide....

Translate

Forum|alt.badge.img+6

Hello!

‌ I removed the "+" but still nothing happened. Thanks anyway. ‌ I didn't realize I could post screenshots until I saw that you and others replied in that way. I see now the insert an image option. Thanks for bringing it to my attention. ‌ thanks for the explanation do you know if I can use kwizcom after I publish the nintex form? Kwizcom lets set a date but overwrite it.

Translate

Forum|alt.badge.img+8
  • Dec 7, 2017 1:57 PM UTC

Jennifer, it's even easier than that. Just paste a copied image in the post as you would into a Word doc. Are you trying to overwrite the Created date?

Translate

Forum|alt.badge.img+6

‌ Thx but copy/paste or ctrl v doesn't work for me in this forum for some reason. I'd like to have a default date for the SLA but it should be able to be overwritten as needed.

Translate

Forum|alt.badge.img+8
  • Dec 7, 2017 6:13 PM UTC

You should be able to update the SLA date field in the workflow.

Translate

Forum|alt.badge.img+14
  • Scholar
  • Dec 8, 2017 9:33 AM UTC

I'm sorry, I do not know what is kwizcom

Translate