Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!

Validating Dates Based on Previous Row


Level 2

Have a dynamic table and am trying to validate the current row's date field (DateTimeField1 for i) against the previous row's date field (DateTimeField2 for i-1) and an event start date with a fixed field (PStart_Date). 

var rowCountY = this.resolveNodes("RowX[*]");

for (var i=0; i < rowCountY.length; i++)


if ((PBE.Page2.SubFormEcho.SubformCharlie.TableA.RowX.DateTimeField1.rawValue >= PBE.Page1.ProjectInfoSubform.Table3.Row3A.PStart_Date.rawValue) && (PBE.Page2.SubFormEcho.SubformCharlie.TableA.RowX.DateTimeField1.item(i).rawValue >= PBE.Page2.SubFormEcho.SubformCharlie.TableA.RowX.DateTimeField2.item(i-1).rawValue))

        {this.rawValue = this.rawValue




xfa.host.messageBox("The check-in date must be greater than the previous check-out date and the check-in date cannot be before the event start date.";

this.rawValue = ""




Thanks in advance for any help!

0 Replies