Hello guys,
I face a usual problem everyday as some of the records for valid to field come in the form 30.9999.
I usually change these fields manually to a valid format i.e. 31.12.9999 in an Error DTP and then load the data.
Can anyone help me in writing a routine for these fields so that the data which comes in the form mm.yyyy is converted to 31.12.9999 automatically.
Quick response is much appreciated.