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’

date1

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

file2

Leave a Reply

Your email address will not be published.