Skip to Content
0
Former Member
May 19, 2010 at 01:31 PM

Need logic for my requirement

68 Views

Hi,

One new development i got.Can somebody let me know how to do??please help

New Program needs to loop through table QMEL and whenever QMEL-QMDAT (Notification Date) is not equal to QMEL-ERDAT (Create Date), move QMEL-ERDAT to QMEL-QMDAT and update the table.

Example from table QMEL.

We can see below dates in ERDAT and QMDAT fields that is not equal , but as per requirement new program should amend QMDAT date same as ERDAT date. that mean QMDAT will be 06/11/2006 after program execution.

Table : QMEL

ERDAT QMDAT

06/11/2006 06/10/2006