https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/10492.aspxSun, 24 Sep 2006 15:20:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:10492trufooser0https://www.infopathdev.com:443/forums/thread/10492.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=10492I posted a formula around here for an age calculator. Instead of calculating number of years, you could change it to number of days. Subtract Today() from your field and if its &gt;= 6 it fails. Do a search for Age Calculation or Age Calculator, youll find the thread.https://www.infopathdev.com:443/forums/thread/10491.aspxThu, 21 Sep 2006 07:19:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:10491Patrick Halstead0https://www.infopathdev.com:443/forums/thread/10491.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=10491Hi Beth,<br />Unfortunately, you have to use code to do this. Take a look at the js code in the Timesheet (Detailed) sample. It has code to calculate the totals I think (see common.js). Good luck!https://www.infopathdev.com:443/forums/thread/5843.aspxWed, 20 Sep 2006 14:19:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5843bbujak0https://www.infopathdev.com:443/forums/thread/5843.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5843I have a form with a repeating table. The form is also has an access database as its data source.<br />There is a week ending field in a repeating section. Within that repeating section is a repeating table which has a field start date.<br />I need to validate whether the start date is &lt;= Week Ending date and &gt;= Week Ending Date - 6.<br />I can validate the first part but not the Week Ending Date - 6.<br />I realize that this will have to be done in code, but my problem is that I have trouble identifying the current row of the repeating table in code. It always seems to calculate using the fields in the first row. I use VBScript.<br />Please help.<br />Thanks....Beth<br />