excel voucher upload - date format change

Hi,

We are trying the implement the excel voucher upload.

I have made the changes for the single payment voucher and everything is working fine.

I got stuck at the last point where we have to change the format of the dates in the voucher template.

The delievered format is yyyy-mm-dd.

We have to change the format to mm/dd/yyyy in the data entry page,.

I am not sure if there is any option to change it in the setup instead of making the coding changes.

I tried to change the format of the column in the data sheet, but the rows are getting rejected.