cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Infopath: field value based on a formula.

I am looking to subtract one date from the other and based on the result have the field (multiple choice) value change. For example (field1-field2) > 2days = "yes"

Labels: (1)
0 Kudos
Reply
2 Replies
Automation Master
Automation Master

Re: Infopath: field value based on a formula.

datediff function in InfoPath doesn't exist.

what I would do is

  1. rule on date field 1 - set field value, textbox 1 to be date field 1 add days 2
  2. rule on date field 2 - set field value, textbox 2 to be yes if date field 2 is > textbox 1
  3. rule on date field 2 - set field value, textbox 2 to be no if date field 2 is <= textbox 1
0 Kudos
Reply
Automation Master
Automation Master

Re: Infopath: field value based on a formula.

https://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

haven't played with this myself but let me know if you do and it works

0 Kudos
Reply