Leading '0' drop off from date format 'MM/DD/YYYY' in CSV file
Hi All,
I'm trying to load a data from CSV file using a file layout. It has a date field in the MM/DD/YYYY format. In the file, the date field value which is showing as '01/01/2018' which is correct however the system is not accepting it since while passing the value from the file, it is passing '1/1/2018' dropping the leading '0'. When I open the file in texpad, it is showing as '1/1/2018'.
Is there any possible way, it can be handled at the system level to accept the date format as '1/1/2018'? Please advice any possible solution on this issue.