Calculating age in Repeating tables

[BethB]

I have a form with a repeating table. The form is also has an access database
as its data source.
There is a week ending field in a repeating section. Within that repeating
section is a repeating table which has a field start date.
I need to validate whether the start date is <= Week Ending date and >= Week
Ending Date - 6.
I can validate the first part but not the Week Ending Date - 6.
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.
Please help.

 

[S.Y.M. Wong-A-Ton]

You can use either eventObj.Site
(http://msdn.microsoft.com/library/en-us/ipsdk/html/xdproSite_HV01021332.asp?frame=true)
or eventObj.Source
(http://msdn.microsoft.com/library/en-us/ipsdk/html/xdproSource_1_HV01021336.asp?frame=true)
to identify the node where validation is taking place, and then navigate the
DOM starting at that node to find other nodes and their values.