How to send date value from Peoplesoft App engine to PS connected query date prompt?
I am using the below code to send date prompt to ps query but the connected query is not giving any results. When we hardcode the values in connected query, the process works :(
&recQueryParameters1 = CreateRecord(Record.PSCONQRSRUNPRMX);
&recQueryParameters1.OPRID.Value = %OperatorId;
&recQueryParameters1.RUN_CNTL_ID.Value = B_PA_LNM_AET.RUN_CNTL_ID;
&recQueryParameters1.CONQRSNAME.Value = &lstrConnectedQueryName1;
&recQueryParameters1.QRYNAME.Value = &lstrQueryName1;
&recQueryParameters1.BNDNUM.Value = 1;
&recQueryParameters1.FIELDNAME.Value = "FROM_DT";
&recQueryParameters1.BNDNAME.Value = "BIND1";
rem &recQueryParameters1.BNDVALUE.Value = "2022-11-16";
&recQueryParameters1.BNDVALUE.Value = B_PA_LNM_AET.FROM_DT;
&recQueryParameters1.Insert();