https://www.infopathdev.com:443/forums/131.aspxqRules adds support to your InfoPath forms. With qRules, you can add features to your form that require code, but without having to write it. enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/106174.aspxThu, 14 Apr 2016 22:46:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106174Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/106174.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=106174<p>You need to use a concat formula. In the formula editor:</p><blockquote style="margin-right:0px;" dir="ltr"><p> concat(&quot;DateDiff /date1=&quot;, <em><u>EndDate</u></em>, &quot; /date2=&quot;, <em><u>today()</u></em>,&quot; /component=days&quot;)&nbsp;</p></blockquote>https://www.infopathdev.com:443/forums/thread/106172.aspxThu, 14 Apr 2016 22:07:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106172scrivies0https://www.infopathdev.com:443/forums/thread/106172.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=106172<p>&nbsp;I need to find the number of days between today and InfoPath field: &nbsp; EndDate</p><p>I have tried every DateDiff command syntax I can think of after reading thru&nbsp;the documentation but I just can&#39;t get it right:</p><p><strong>DateDiff /date1=/my:myFields/my:group1/my:group2/my:EndDate /date2=Today() /component=days</strong></p><p>&nbsp;I have set a rule: Set fields value:&nbsp; COMMAND&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;with the above in the value.&nbsp;</p><p>&nbsp;In preview, the ERROR field shows:&nbsp; &quot;The first date is invalid.&quot;</p><p>&nbsp;</p><p>What am I missing?</p><p>&nbsp;</p>