Invoice date format error notification in ADFDI template

While creating an AP Invoice via ADFDI spreadsheet, the date field requires the date to be entered in a specified format. If the format is not compatible, the system will error out indicating that the line insert has failed because the input value cannot be converted to an expected data type. But this error will be displayed only upon giving “Save and Submit Invoice Import” option. The requirement is for the system to have a mechanism where the indication of the date format error is notified to the user at the time of entering the date rather than throwing the