I need to find the number of days between today and InfoPath field: EndDate
I have tried every DateDiff command syntax I can think of after reading thru the documentation but I just can't get it right:
DateDiff /date1=/my:myFields/my:group1/my:group2/my:EndDate /date2=Today() /component=days
I have set a rule: Set fields value: COMMAND with the above in the value.
In preview, the ERROR field shows: "The first date is invalid."
What am I missing?