Convert the code

[PGStats]

Now you can validate the original Oracle code !

[Ahsan]

hi pg,
Yes I validate it looks perfect thank you very much. I just have a quick question I have the same scenario this time the business logic is like this

"Member Age at end of the State Fiscal Year
June 30. Determine end of SFY (yyyy) from RPT_PERIOD (yyyymm). Calculate MBR_AGE_EOS at 6/30/yyyy according to MBR_BRTH_DT."

Can I use the same code and change 7 into 6

[PGStats]

Not really, you should use

age = intck("YEAR", <mbr_brthdt>, intnx("YEAR.7", <rpt_period>, 0, "END"), "CONTINUOUS");

[Ahsan]

works like a charm you are the best

[Ahsan]

Hi PG Stats,

I need your help that 's the Business logic I need to calculate the "Member age at beginning of the month each month. Calculate MBR_AGE_BOM using RPT_PERIOD_BEG_DT.

I appreciate all the help.

[PGStats]

Please post as a new topic, including what you have tried so far. Hint: consider mixing the approach given above with the MDY() function.