https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/95092.aspxThu, 09 Jan 2014 03:17:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:95092donstephen0https://www.infopathdev.com:443/forums/thread/95092.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=95092<p>Hi jjsmith, </p> <p>You might want to take a look at <a href="http://msdn.microsoft.com/en-us/library/bb862071.aspx">this</a> link for date formulas, or you can use <a href="http://www.qdabra.com/en/products/qRules_new.aspx">qRules</a>&#39; DateDiff command if you wish to avoid writing code.</p> <p>&nbsp;Hope this helps.</p>https://www.infopathdev.com:443/forums/thread/95076.aspxWed, 08 Jan 2014 16:45:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:95076jjsmith0https://www.infopathdev.com:443/forums/thread/95076.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=95076<p>This might sound simple but I am fairly new to InfoPath.</p> <p>In one of my fields I need to take whatever today&#39;s date is and subtract it from a date picker field to get a number value.</p> <p>Example... <span style="LINE-HEIGHT:115%;FONT-FAMILY:&#39;Calibri&#39;,&#39;sans-serif&#39;;FONT-SIZE:11pt;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:&#39;Cordia New&#39;;mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;">=(Today)-Open Date</span></p> <p><span style="LINE-HEIGHT:115%;FONT-FAMILY:&#39;Calibri&#39;,&#39;sans-serif&#39;;FONT-SIZE:11pt;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:&#39;Cordia New&#39;;mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;">What calulation do I use?</span></p>