https://www.infopathdev.com:443/forums/40.aspxFor browser form specific questionsenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/93345.aspxMon, 30 Sep 2013 05:24:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:93345Jimmy0https://www.infopathdev.com:443/forums/thread/93345.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=93345<p>&nbsp;Assuming you are using an ordinary list connection, the formula would be something like this (I&#39;m abbreviating here):</p><blockquote><p>SharePointListItem_RW[translate(substring(EffectiveDate, 1, 10), &quot;-&quot;, &quot;&quot;) &gt;= translate(substring(FormDate, 1, 10), &quot;-&quot;, &quot;&quot;)]/Amount</p></blockquote><p>&nbsp;Note that in order for this to work, the connection would have to be sorting the results in order of the effective date (ascending).</p>https://www.infopathdev.com:443/forums/thread/93225.aspxTue, 24 Sep 2013 13:46:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:93225mwu18760https://www.infopathdev.com:443/forums/thread/93225.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=93225I have a list with a &quot;effective date&quot; column and an &quot;amount&quot; column. I want to auto-populate a field in the form with the most current rate. To do this, I&#39;ll need to lookup the closest date from the date I have in the form and populate with the amount. How can I perform that filter/lookup?