Skip to Content
1
Former Member
Jan 10, 2012 at 10:41 AM

Date field is blank in the flat file , how to handle it in BW

871 Views

I have 2 dates in my flatfile posting date, cal date . The dates in the flat file are in the format 31.01.2011 .

In the datasource, Im getting these dates as "ëxternal" format and it works fine and i get the date in the PSA as 31.01.2011 and able to load it till cube. The problem is when one of the posting or cal date is blank then it errors out @ PSA load as "date format not allowed in the date field".

I modified the date field in datasource to use a NUMCV conversion routine with external format and now the spaces are allowed, but the problem is the existing correct records are not coming correctly.

can you please suggest on how to handle the blank dates from flatfile into datasource.