How to load the csv file having date in MM/DD/YYYY format
The flat file loaded to BW must be in csv format. If the file has calendar day in the format MM/DD/YYYY or MM.DD.YYYY or DD/MM/YYYY or DD.MM.YYYY, the file gets loaded but PSA shows the incorrect date as
YY.YY.MMDD or something like that.
To ensure that the date is correctly loaded to BW, we need to make some settings in the flat file data source to handle the date formats entered by the user in the file.
Create a data source and maintain the fields.
Enter 0calday for the date field.
In the conversion routine column, select RSDAT and in the Format column select ‘External’
Save and activate the data source.
Now when the file is loaded, the dates will be read correctly and can be seen in the PSA as DD.MM.YYYY