Oct 02 2019 02:23 AM
Oct 02 2019 02:23 AM
Hi,
I need to generate monthend date as of today from the due date. please advise how to do it.
sample input record
TRX_NUMBER | TRX_DATE | GL_DATE | TRX_CLASS | STATUS_TRX | DUE_DATE | INVOICE_AMOUNT | AMOUNT_REMAING | ACCT_AMOUNT_REMAING | SYSDATE_DUE |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 |
output record (AS_OF_DATE AS MONTH END DATE)
TRX_NUMBER | TRX_DATE | GL_DATE | TRX_CLASS | STATUS_TRX | DUE_DATE | INVOICE_AMOUNT | AMOUNT_REMAING | ACCT_AMOUNT_REMAING | SYSDATE_DUE | AS_Of_DATE |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 10/1/2019 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 9/30/2019 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 8/31/2019 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 7/31/2019 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 6/30/2019 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 5/31/2019 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 4/30/2019 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 3/31/2019 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 2/28/2019 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 1/31/2019 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 12/31/2018 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 11/30/2018 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 10/31/2018 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 9/30/2018 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 8/31/2018 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 7/31/2018 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 6/30/2018 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 5/31/2018 |
12345 | 4/8/2018 | 4/8/2018 | INV | OP | 4/8/2018 | 34388.8 | 0.8 | 0.8 | 0.8 | 4/30/2018 |
Oct 02 2019 10:33 PM
Oct 03 2019 03:54 AM
@Deletedquestion unclear
you ask "...monthend date as of today from the due date..."
in your example DUE_DATE constant, but AS_Of_DATE coundown by month
need more details
Nov 05 2019 06:29 AM