In Web ADI - Default Expenditure/Week Ending Date based on Expenditure Item Date field in ADI Excel

Hi,

We used seeded Projects Transaction Import ADI and created new layouts to suit our needs.

One of the requirement we have is to automatically default/derive the Expenditure Ending Date based on the Expenditure Item Date entered by the user.

I know we have pa_utils.GetWeekEnding(Exp Item Date)function, but want to know how I can use this function in the Web ADI layout definition, so that Expenditure Item Date entered in the ADI/Excel is passed to this function and Expenditure Ending Date is derived dynamically in the Expenditure Ending Date field.

Would like to hear how others tackled this. If we cannot use the function