Skip to Content
0
Former Member
Aug 02, 2016 at 08:19 AM

Routine to change Date in Error DTP

127 Views

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.