Hi,
I have a field of type SY-DATUM and I am loading data from an external system into BW. The field should be of the format YYYYMMDD (Ex: 20051025). But I have some corrupt data where the field is not in the specified format. Sometimes the date is in othe formats, for example 05/02/054, 20/04/04 and some other formats.
Well, When the field is not in the correct format, I would like to set the field to NULL. Any ideas appreciated.
Thanks
GOva