Hello,
Would you like to help me in this regard?
There is an issue with Date format in filelayouts using App Engine program.
Here are the Details:
1)When we are using the the date format as DD/MM/YYYY the App engine (through CI) is running to success and data is loading into the Database.
Sample csv with valid date format : 011060K|03|ITA|S|N||RONAL|LEE|||||||||||||Y|||N|24/05/1985|||
2)When the date format is changed to MM/DD/YYYY and running through App engine is success, But the date field value is fetching null value, even though the value is given in the CSV file(Please see the sameple CSV file below) and the data is not updated in the database.
Sample csv with invalid date format : 011060K|03|ITA|S|N||RONAL|LEE|||||||||||||Y|||N|05/24/1985|||
Please let me know if you know the answer ASAP on this regard. thanks.
Cheers..
Regards
Kiran
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
You can user the %date() function and set the format of date in Input file array/record
--
Simrose
Post new comment