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/106206.aspxMon, 18 Apr 2016 12:21:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106206Patrick Halstead0https://www.infopathdev.com:443/forums/thread/106206.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=106206<p>The date fields use a string format like this: 2016-04-18</p><p>You can strip off the year using the substring function. Try substring(field,5,5).&nbsp; Then you can compare that to 02-16 and/or 03-15.</p><p>To do a numeric comparison, you can remove the hyphen&nbsp;(-) character &nbsp;using the translate(field,&quot;-&quot;, &quot;&quot;) command and number function. You&#39;ll need another field in your form to take the result.</p><p>We can help with this and it won&#39;t take much support time.</p><p>Good luck!&nbsp;</p>https://www.infopathdev.com:443/forums/thread/106197.aspxSun, 17 Apr 2016 06:00:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106197emgre0https://www.infopathdev.com:443/forums/thread/106197.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=106197Hi, I am working on a form where I need to automatically set a calendar period (like below) based on today&#39;s date. <b><br />If today() greater than 16/02 and today() Less than 15/03, Set Period to 16th February to 15th March</b>