PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Leading '0' drop off from date format 'MM/DD/YYYY' in CSV file

edited Apr 5, 2018 5:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center